>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 ALWAYS, (ALWAYS!!!) have something like this:
@ 123123.123asdasdasdasdasdasd
Then you could use:
?VAL(SUBSTR(YourMemo, ATC("@ ", YourMemo)+2))
VAL function will remove all non numeric chars at the end of the expression.
so if you have:
lcStr = "bla bla @ 12324.55asdasdasd"
?VAL(SUBSTR(lcStr, ATC("@ ", lcStr)+2))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.