Check if first 6 characters are same as on a list

[HarryRoles]

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 solution]

Hi @HarryRoles,

I have created a workflow for you:

The output:

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

[AngelosPachis · Accepted solution]

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

[mbarone]

Many ways to do this.  I'd probably go with a left function to create a new field for the first 6 characters, then join them to your reference file, and there they join would be your "YES", and where they don't would be your "NO".