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 ) ;