FM - Can You Put Wildcards in the Calculation Box?

rvfowler2
rvfowler2 used Ask the Experts™
on
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 ) ;
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Will LovingPresident, Dedication Technologies, Inc.
Commented:
If you have the city in another field or can derive it using a zipcode lookup table, you can create a calculation along the lines of:

Substitute( AddressAndCity ; Zipcode::City ; "" )
Commented:
you could try to wordcount untill 'Hwy' + 1 word
that would give something like:
LeftWords ( address; WordCount ( Left(address;Position(address;"Hwy";1;1))) +1 )

Author

Commented:
Thanks, those were both helpful, I'll look into it, but I guess the answer to my question was that there aren't wildcards in the calc box the way their are in Find.

Commented:
indeed, no wildcard in calcs...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial