Search for Character 1

[greggb]

Sorry for the elementary question, but I am racking my brain trying to figure out the best way to search for a particular character (or string) columnn by column in a table, regardless of where it might be in the cell.

Can anyone help me?

 

[danceman]

AT( ) Function
Returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, counting from the leftmost character

Attitude is Everything

 

[xBaseDude]

greggb;

SELECT * ;
    FROM mydbf ;
    WHERE ([Z] $ UPPER(myfield1))

* OR

SELECT * ;
    FROM mydbf ;
    WHERE ([Z] $ UPPER(myfield1) ;
        OR ([Z] $ UPPER(mfield2)) ;
        OR ([ABC] $ UPPER(mfield3)))

HTH - Wayne

 

[Mike Lewis]

Greggb,

Are you saying that you don't know which field the character will be in? If so, you need to loop through all the fields in the record, something like this:

SELECT MyTable
FOR x = 1 TO FCOUNT()
IF TYPE(x) = "C" OR TYPE(x) = "M"
* Do this with char and memos only
str = EVAL(FIELD(x))
IF AT(SearchChar,str) > 0
* Found
* Take appropriate action here
EXIT
ENDIF
ENDIF
ENDFOR


I haven't tested this, but I think it'll work.

Mike



Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[DSummZZZ]

Take a look at this FAQ:

How do I change grids' row/column colors/fonts, ...
faq184-3098

Specifically, section 6:
6- Hilight cells of grid for searched text



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm