Regulars Expression Of Word

[minal.patil]

Hello

I can get “OPERA AR AGIN” of 1st line and “OPERATB” of line 2nd using regulars expression. How can I get this value/words.

Line 1:
“567848 5 Hard-Po S185605 AR AGING PERIOD5 35,435.72 Deb US 35,565.72 1.000000000 0.00000 OPERA AR AGIN OPERAMGR”

Line 2:
“955633 1 Hard-Po 104779 Ledger Clearing Account - 14,567.70 Deb”,"USD 14,617.70 1.000000000 0.00000 OPERATB OPERA TR

[Steven_McKeering]

Hey @minal.patil

Can you explain further?

Do you want to check if those texts exist?

Check out my MegaPost if you want to learn more:

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Cheers

Steve

[THIRU_NANI (NaNi)]

Hey!

Try this

System.Text.RegularExpressions.regex.match(StrInputVariable,"\s+\D+$").ToString.Trim

Regards,
NaNi

[Yoichi]

Hi,

Can you try the following expression?

mc = System.Text.RegularExpressions.Regex.Matches(yourString,"OPERA.*?(?=\s*OPERA)")

Sequence1.xaml (6.8 KB)

Regards,

[minal.patil]

Thanks, it’s Works.

[THIRU_NANI (NaNi)]

Hey!

Mark the appropriate post as solution and close the thread…

Regards,
NaNi

[minal.patil]

it’s also select OPERAMGR of 1st line and OPERA TR of second line.

I have o/p : 1st line is only "OPERA AR AGIN "
2nd line is only “OPERATB”

[minal.patil]

@minal.patil

955633 1 Hard-Po 104779 Ledger Clearing Account - 14,567.70 Deb”,"USD 14,617.70 1.000000000 0.00000 OPERATB 13096

and this line, because some time after the output word is number or symbol also

[Yoichi]

HI,

I don’t understand your requirement perfectly, but can you try the following expression?

System.Text.RegularExpressions.Regex.Matches(yourString,"OPERATB|(OPERA.*?(?=\s*OPERA))")

Sequence1.xaml (6.8 KB)

Regards,

[minal.patil]

sorry , I can’t get proper solution. Sorry for my yesterday reply.

[THIRU_NANI (NaNi)]

Hey!

Try this:

Regards,
NaNi