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 ) ;
LVL 2
rvfowler2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 ; "" )
0
lesouefCommented:
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 )
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rvfowler2Author 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.
0
lesouefCommented:
indeed, no wildcard in calcs...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.