How to extract price value from this text

[vinjam_likitha]

Hi,

TextVal=“Service Request is closed. RAMSAY HEALTH CARE AUSTRALIA PTY LTD will be billed AUD 25.(SBL-BPR-00131)”

I want to extract value after “AUD” before “.(”

output value should be “25”

Please Suggest me if you have any solution

Thanks
likitha

[hafiz.ahsan (Hafiz Mohammad Ahsan)]

You can use the Substring() Method to get the value of your expected text

[vinjam_likitha]

Hi,

Can you please elaborate

[Sanjit_Pal]

Hey @vinjam_likitha,

You can use regularexpressions to get that value.

System.Text.RegularExpressions.Regex.Match(TextVal,"AUD\s+\d+")

Thanks,
Sanjit

[hafiz.ahsan (Hafiz Mohammad Ahsan)]

Like this given picture

[Yoichi]

Hi,

@vinjam_likitha

I want to extract value after “AUD” before “.(”

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(TextVal,"(?<=AUD\s*)\d+(?=\.\()").Value

]

Regards,

[rohith.prabhu]

Hello @vinjam_likitha ,

System.Text.RegularExpressions.Regex.Match(TextVal,“(?<=AUD)\s+\d+”)

Regards,
Rohith

[Gokul_Jayakumar (Gokul Jai)]

@vinjam_likitha

RAMSAY HEALTH CARE AUSTPreformatted textRALIA PTY LTD will be billed AUD 25.(SBL-BPR-00131)

Hello @vinjam_likitha
Try Regex method

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=AUD).*(?=\()").ToString.Trim

If need as integer variable try this

Cint(System.Text.RegularExpressions.Regex.Match(YourString,"(?<=AUD).*(?=\()").ToString.Trim)

[Gangadhar_Athili]

[vinjam_likitha]

Hi All,

Thank you for the solutions

Thanks
Likitha