>Hello all,
>
>I am using the ATC() function to locate a substring within a memo field. I will find the string I am looking for and determine the starting position and length of the substring to return the needed substring. This was working because I assumed a certain character would never be used in the memo field and this character is now being used. Now I want to search for that string with only numeric values following it. For example, I want to extract a price from a memo field that has and '@' sign followed by a space and then some numeric value.
>
>Can I use the ATC() function to search for a string with a wildcard for numerics, and if so what is the wildcard? Or is there another function I can use to do this?
>
>TIA
You could write your own ('wildcard') search calling ATC() for each '@' occurence and then checking subsequent characters.
Anyway, given time-consuming constraints, if any exist, I would consider changing the way you store data. It might be reasonable to keep price in separate field instead of memo.
Edward Pikman
Independent Consultant