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

How to extract price value from this text

Yoichi (Yoichi) September 13, 2022, 5:48am 6

Hi,

Can you try the following expression?

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

]

Regards,

Topic		Replies	Views
Extracting the values from Text Help activities , web , question	4	893	January 26, 2021
Which regex expression to use in order to be bale to select the second number of AUD? Studio studio , question , activities_panel	9	900	June 6, 2022
Help with Regex to get a value Studio studio , question , activities_panel	6	949	November 3, 2021
How to get Particular value from a string using Regex Expression? Studio studio , question , activities_panel	3	527	April 28, 2023
Extract total cost from string by regex Academy Feedback academic_alliance , question	7	1451	July 1, 2021