rvfowler2
asked on
FM - Can You Put Wildcards in the Calculation Box?
Trying to separate out addresses and cities that have been placed in the same field with only a space to separate them. I've captured many street abbreviations, but how would I capture the address for something like 100 Hwy 16 Los Angeles? I attempted to put a Find wildcard of ** like you see below to capture a two-digit number, but it didn't work. Are there any wildcards that can be used in a calculation field?
PatternCount ( SuperMarketsList::Address; "Hwy ") = 1;
Left ( SuperMarketsList::Address ; Position ( SuperMarketsList::Address ; "Hwy ** "; "" ; 1 ) + 2 ) ;
PatternCount ( SuperMarketsList::Address;
Left ( SuperMarketsList::Address ; Position ( SuperMarketsList::Address ; "Hwy ** "; "" ; 1 ) + 2 ) ;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
indeed, no wildcard in calcs...
ASKER