Regulars Expression Of Word

Help Studio
1

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

2

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:

Cheers

Steve

1 Like
3

Hey!

Try this

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

Regards,
NaNi

4

Hi,

Can you try the following expression?

image
image1184×692 39.5 KB 

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

Sequence1.xaml (6.8 KB)

Regards,

5

Thanks, it’s Works.

1 Like
6

Hey!

Mark the appropriate post as solution and close the thread…

Regards,
NaNi

7

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”

8

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

9

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,

10

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

11

Hey!

Try this:

Matches
Matches1828×802 41.4 KB

Regards,
NaNi