Need to Extract the data before the match word using Regex

Help Studio
, , , ,
1

This is the string “gsdx 15h x 1jj 3.144 GA 5,67 INR 79.675,60”,I need to extract the 3.144 by using GA as match character and the other one is need to extract 5,67 by using INR as match character,Thanks in Advance

2

@raghuram_katuri
(?<=GA\s)(.?(?=INR))
[\d.]+\s(.?(?=GA))

3

Hi,

How about the following pattern?

[\d.,]+(?=\s*GA)

image

[\d.,]+(?=\s*INR)

image

Regards,

4

Hey hope this helps @raghuram_katuri
Here we are using look before the keyword GA and INR
system.text.regex.regularexpression.match(“InputString”,“(\d{0,},{0,}\d{0,})(?=\sINR)“).value
system.text.regex.regularexpression.match(“InputString”,”(\d{0,}.{0,}\d{0,})(?=\sGA)”).value
image
image

Cheers.

5

Post Updated. Happy Automation

6

Thanks @raja.arslankhan

1 Like
7

Thanks @Yoichi

8

@raghuram_katuri Thanks…Happy Automation

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.