Matching the same expression

[Krishna_Sanghi]

Hi everyone

I have a pattern which comes in excel like

Now their might be empty cell or these 3 types of pattern. these all needs to be accepted for any other pattern or any count less or something it must say it is invalid.
and these 3 no.'s written have a very small difference… Please anyone try this . Urgent…

[Pradeep_Shiv]

Hello Krishna,

so you want to iterate through each row and validate this pattern??

[Krishna_Sanghi]

hi @Pradeep_Shiv

yes

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @Krishna_Sanghi

Others with good regex knowledge can have a better elegant solution, but here is the basic string check.

I see that the string pattern can have 24 character and 6 underscores (or 7 parts when split on _)

IF: row("PatternColumn").ToString.Split("_"c).Count = 7 AND row("PatternColumn").ToString.Length = 24
Then : Do something
Else : Ignore or Invalid

Here is the suggestion: PatternMatch.xaml (7.6 KB)

Hope this helps!

[Pradeep_Shiv]

Hello @Krishna_Sanghi,

Sorry for the delay!

• Use Read Range, and get output like outDt

• For each row, Pass outDt

• Use IF Activity like Not String.IsNullOrEmpty(row(“yourColumnName”).ToString)

Then: IsMatches Activity and pass input as row(“yourColumnName”).ToString and Pattern as [A-Za-z]{1}_\d{6}_\d{3}_[A-Za-z]{2}_\d{4}_[A-Za-z]{1}_[A-Za-z]{1}

Else: Row value is empty

if the pattern matches you’ll get return output as True if not False based on the output you can develop the process.

you can test the expression here Regex

Cheers
@Krishna_Sanghi

[Krishna_Sanghi]

Hi @Pradeep_Shiv

Thanks for the solution, I was not able to develop this regexp. It works