Help how do i create a trycatch for each?

Hi there my project involves entering a 7 digit numbers from excel to another excel file, I am trying to add a catch error function. So when there are 6 digits or 8 digits numbers in the excel file, the code will continue to run instead of stopping now. Since I only want 7 digit numbers data, is there any ways to filter out 6 or 8 digit numbers ? Thanks alot

HI,

In this case, probably it’s unnecessary to use try catch, i think.

Can you try the following condition and use Continue activity.

System.Text.RegularExpressions.Regex.IsMatch(CurrentRow("Target").ToString,"^\d{7}$")

Or we might be able to achieve it to filter datatable in advance, too.

Regards,

Hi @carrisatann

I have developed few steps about your query. Please, find the below image.

Regards, I hope it may helps you!!