D
Dave R
I need to parse out and identify a country from a string
similar to: Yorkton Sk Canada S3n 2A8. I have a list of
countries in a separate table.
What I've done so far is to identify the blank characters
and segregate each word (Yorkton,Sk, etc.) into separate
fields.
Is there a way to do a lookup of all 5 cells and to
return the value that matches a value in the lookup table?
Any other suggestions on how to take the example and to
pull "Canada" from it based on a lookup table?
similar to: Yorkton Sk Canada S3n 2A8. I have a list of
countries in a separate table.
What I've done so far is to identify the blank characters
and segregate each word (Yorkton,Sk, etc.) into separate
fields.
Is there a way to do a lookup of all 5 cells and to
return the value that matches a value in the lookup table?
Any other suggestions on how to take the example and to
pull "Canada" from it based on a lookup table?