Need Help To Design REGEX For A Given Text/String

[Panda_Baruna_K]

Hi,

I have been working for a complex project, for that a regex extraction is required. For some of regular expression, I have designed. But for others am struggling.

I need support to design the REGEX for strings am struggling for, strings are listed below.

1. Total nett amount: CZK 4,305.52

Here I need regex to capture the amount

2. Weight (gross / nett): 48.50 / 48.50 KG

here I need the regex to capture the both weights.

Your help will be appreciated.

Thanks & Regards,
Baruna K Panda

[Gokul001 (Gokul Balaji)]

Hi @Panda_Baruna_K

System.Text.Regularexpressions.Regex.Match(yourString,"(?<=CZK\s)(\S+)").tostring

Regards
Gokul

[Sanjit_Pal]

Hey @Panda_Baruna_K,

you can use \d.+\d

Thanks,
Sanjit

[Gokul001 (Gokul Balaji)]

@Panda_Baruna_K

Weight (gross / nett): 48.50 / 48.50 KG

@Panda_Baruna_K

System.Text.Regularexpressions.Regex.Match(yourString,"(?<=gross\s\/\snett\):\s).*(?=KG)").tostring

Regards
Gokul

[Panda_Baruna_K]

@Gokul001

"(?<=CZK\s)(\S+)")

Hi Gokul,

The problem with the expression is, “CZK” you have taken reference is dynamic value, so it will change for other data. Only “Total nett amount:” is constant.

Thanks,
Baruna K Panda

[Gokul001 (Gokul Balaji)]

@Panda_Baruna_K

System.Text.Regularexpressions.Regex.Match(yourString,"\d.*").tostring

[Panda_Baruna_K]

@Gokul001

(?<=gross\s\/\snett\):\s).*(?=KG)

Hi Gokul,

It is capturing though, but it is capturing both at one go. I need to capture one by one, both are separate values & also dynamic in nature.

Thanks
Baruna K Panda

[Gokul001 (Gokul Balaji)]

Hi @Panda_Baruna_K

System.Text.Regularexpressions.Regex.Match(yourString,"\d.*(?=KG)|\d.*").tostring

Regards
Gokul

[Panda_Baruna_K]

@Sanjit_Pal

\d.+\d

Hi Sanjit,

the expression is matching for multiple values in the string, can we capture the “Total net amount:” string only.

Thanks
Baruna K Pada

[Gokul001 (Gokul Balaji)]

Hi @Panda_Baruna_K

System.Text.RegularExpressions.Regex.Match("Total nett amount: CZK 4,305.52","(?<=amount:\s)\D+(\d.*)").Groups(1)

Regards
Gokul

[Sanjit_Pal]

Hey @Panda_Baruna_K,

You can use look after method to get the desired result.
(?<=Total net amount:\s)\d.+\d

Thanks,
Sanjit

[Panda_Baruna_K]

I have found another way to capture that.

i.e (?<=Total nett amount: [A-Z]{3}\s)[\d,.]+

Thanks Sanjit for all your support.

[Panda_Baruna_K]

Hi Gokul,

Thanks for sharing it, I have found a an expression to capture that.

i.e (?<=Total nett amount: [A-Z]{3}\s)[\d,.]+

I appreciate your help.

Thanks.

[Gokul001 (Gokul Balaji)]

Hey @Panda_Baruna_K

The above regex is not working?

[Panda_Baruna_K]

@Panda_Baruna_K

(?<=Total nett amount: [A-Z]{3}\s)[\d,.]+

Hi Gokul,

It is working for me.

[Gokul001 (Gokul Balaji)]

@Gokul001

System.Text.RegularExpressions.Regex.Match("Total nett amount: CZK 4,305.52","(?<=amount:\s)\D+(\d.*)").Groups(1)

This expression is not working ? @Panda_Baruna_K

[Luciano_Gjinaj06 (Luciano Gjinaj)]

@Gokul001

(?<=amount:\s)\D+(\d.*)

I think this is better, the solution it was chosen i doesn’t work for me either