Regex Workflow

[Suryachoppakatla]

Hello Friends,

I am struggling with one of the issue where I need to write a formula which should able to determine the repeating same TIN numbers in a column. If the number is identical and repeated more than once, then the formula should be able to pick and validate it as "Invalid" else "Valid"

I wrote below formula, but it did not worked. NOTE: The TIN numbers are 9 digit 

IF REGEX_Match([Recipient's U.S. TIN], ".*(?:(\d)\1{8})") THEN "Invalid" ELSE "Valid" ENDIF

Attaching the screenshot of the data for quick reference. Any help is highly appreciated

Regards,

Surya

[ShankerV · Accepted solution]

@Suryachoppakatla 

Issue 3: Fixed 

Inherited the 3rd check to be done on the repeated digits in the existing workflow.

[ShankerV · Accepted solution]

@Suryachoppakatla 

Issue 4: Fixed

When the Address Type is O, all the City State and Zip will reflect as Falg for manual review.

[ShankerV · Accepted solution]

Hi @Suryachoppakatla 

Issue 5: Fixed

When the country is below 3, it will reflect as Valid

[ShankerV · Accepted solution]

@Suryachoppakatla 

Issue 6: Fixed

If Zip code for Canada is not equal to length 7 

If Zip code for USA is not equal to length 5 or 10

It will throw as Invalid..

[ShankerV · Accepted solution]

@Suryachoppakatla 

Issue 7: Fixed

Check for the specific format on USA Zip and Canadian Zip are performed and Valid is prompted.

[ShankerV · Accepted solution]

@Suryachoppakatla 

Issue 8: Fixed

The states are cross verified with the additional US States sheet and prompted for Valid or Invalid if not available in the list.

[ShankerV · Accepted solution]

Hi @Suryachoppakatla 

Issue 9: Fixed

The below column is checked for 3 conditions

O contain X mark, then T should surely contain the value
O is blank, T can be blank
(Q+R+S)*24%

[ShankerV · Accepted solution]

Hi @Suryachoppakatla 

Issue 10: Checked

Regression testing is also done to make sure the existing output is not affected post the changes.

Kindly let me know if you need any more assistance on the same.

Happy New Year in advance.

[Suryachoppakatla]

Hello

[Suryachoppakatla]

USStates