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