How to Parse this "ICA" Using advanced Regex?

Help Studio
, ,
1

Hello

I want to Parse the Following Highlighted Words. (ICA is the String) which is Mandatory String

Find the Attached Screenshot

Regex
Regex819×460 11.8 KB

Thanks in Advance

2

Hello @kishan.savaliya

Can you please share the expected output here?

Thanks

3

Hi!

Try this:

strText=System.Text.RegularExpressions.RegEx.Match(strInputVariable,"\w{3}-\w{3}|\w{3}_\w{3}|(?=[A-Z]{3}).+").ToSting

Reference:

Regards,
NaNi

4

Hi @kishan.savaliya

How about this expression

System.Text.RegularExpressions.Regex.Match(YourString,"ICA\S.*|^ica\S.*|\S.*ICA|^ica|^ICA").Tostring

image

Regards
Gokul

5

highlighted Words is Output.

6

@Gokul001 it Working But not Properly…have a Look Attahced SS…

Small ica is not Covered and I did not want APPLICATION,VERIFICATION.

Just want Following Words

ICA
ica
ATO ICA
ATO-ICA
ATO_ICA

image
image865×563 28.3 KB

7

Split on VbCrLf, loop through the array, use an IF to check if the value ends in ICA, add to a second array. Then you’ll have an array of just the values you want.

8

Hi @kishan.savaliya

How about this expression?

System.Text.RegularExpressions.Regex.Match(YourString,"\S.*\wica(?=\s)|\S.*\WICA(?=\s)|\S.*\wICA(?=\s)|ICA$|ica$").Tostring

image

Regards
Gokul