Finding a value then if not found find the value -1 character

Finding a value then if not found find the value -1 character

Post by QWxle » Thu, 01 Mar 2007 04:37:03


Fred

The function doesn't appear to be working. I keep getting undefined
Function, but I've created the module and saved it as you posted.
 
 
 

Finding a value then if not found find the value -1 character

Post by QWxle » Thu, 01 Mar 2007 04:48:20

No. I need this to be automated. There will be a field called hier
containing different values, ex nick, mabn, etal, etc. I need to be able to
search another field, hier2 to see if these are located in there, perphaps
like [hier]*. But when the find that value in hier 2 will place the hier
value in the new created field.

 
 
 

Finding a value then if not found find the value -1 character

Post by QWxle » Thu, 01 Mar 2007 04:53:30

actually Fred he code somewhat works, except when it searches for the value
it has to be in the beinning of the value of the other field. Also returning
Null values even when I put criteria "is not null" Its returning with results
such as: Searching for GON, returns BRGOD, RAXGON, and GOBAC. It should only
return with GOBAC.