searching text string

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I need some help with searching a text string using the
like statement and wild cards, but also would like to be
able to match case on the search or not match case.

Thanks
 
Hi Mike

There are so many posibilitys,
I think the best you can do is look at :
- string members (indexof, lastindexof, indexofany, lastindexofany)
- the "Like" operator
- the "regex"
- the Instr and the InstrRev function
- string members (toupper,tolower)
- strconv
I need some help with searching a text string using the
like statement and wild cards, but also would like to be
able to match case on the search or not match case.
Click to expand...

The best is what is the most easy for you to use.

I hope this helps you a bit.

Cor
 
Hi Stanley,

Regular expressions is the way to go - it gets as wild as you want RegEx.
:-)

The System.Text.RegularExpressions.Regex class does the wild-card
matching for the Edit/Find dialogue and within apps. Options include
case-sensitivity, white-space handling, single-line vs multi-line.

Regards,
Fergus
 
Fergus,
You don't believe it, I was thinking for the "regex" command in this case on
top, when I saw the "Like" operand, I had looked at it before in VB.
:-)
Cor
 
Again 200 times corrected therefore unreadable.
You don't believe it, I was thinking for the "regex" command in this case
Click to expand...
on
top, when I saw the "Like" operand, I had not seen it before in VB.
(It maybe exist for centuries (LIKE) but I saw it this morning for the first
time)
 
Hi Cor,

I came across 'Like' once in VB but had no reason to use it. Then, when I
saw it in the query, I thought "what does Like do?" - and had to look it up!
;-)

Regards,
Fergus
 
Back
Top