General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
Edward,
Thank you for the reply. I am in fact storing price in a separate field, however, I need to extract information from a memo field (that is a program generated memo field). So my question still stands as I need to find an occurence of a value with a wildcard within a memo.
If you are aware of using ATC() with a wildcard, please let me know. Or if you know of another function like this.
TIA
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only