Check if first 6 characters are same as on a list

Question

Hi All,

Hoping someone could advise which tool and formula to use for the following scenario:

I need to identify if the first 6 characters of a string match to something on a list, so basically a vlookup but only for the first 6 characters in the string e.g. if a 9 number string has 111111, 123456, 999999 etc as the first six digits.

123456777 - YES

999999000 - YES

777778907 - NO

Hope this makes sense!

Cheers

Harry

Emil_Kos · Accepted Answer

Hi @HarryRoles,

I have created a workflow for you:

The output:

Please mark my post as a solution if this was helpful!

AngelosPachis · Accepted Answer

Hi @HarryRoles ,

To parse the first 6 digits, you can convert you source into a string data type and use a formula tool with a function called Left, which will return X characters from the left of the string.

Then, with a Find & Replace tool, you can lookup if the first 6 digits match and append the flag of "Yes".

Hope that helps,

Angelos