Need extract data rfom text file using Regex

[shruthi_arali]

I need to extract the below data from the attached text file.
Data : 158.75

pdf_text_file.txt (5.4 KB)

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(strData,"(?<=TOTAL\s+AMOUNT\s+\(INCL\.\s+TAX\)\s+)[\d.,]+").Value

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@shruthi_arali

Str_outRegex=System.Text.RegularExpressions.Regex.Match(Input,“Expression”).Value

[Parvathy (PS Parvathy)]

Hi @shruthi_arali

You can give this Regex Expression in Find Matching Patterns:

(?<=TOTAL\sAMOUNT(.*)\s)[\d.]+

Use this syntax in Assign activity:

Matches= System.Text.RegularExpressions.Regex.Matches(yourstringinput,"(?<=TOTAL\sAMOUNT(.*)\s)[\d.]+")

Datatype of Matches is IEnumerable(System.Text.RegularExpressions.Match)
Print it in a message box by using below syntax:
Matches(0). This expression will extract an single value. If you have multiple values run a for each for matches.

Use this syntax in Assign activity. It will extract the first Matched value:

Matches= System.Text.RegularExpressions.Regex.Match(yourstringinput,"(?<=TOTAL\sAMOUNT(.*)\s)[\d.]+").Value

Datatype of Matches is String
Print it in a message box by using below syntax:
Matches.toString

Hope it helps!!

[vinitha_yachamaneni]

Hi @shruthi_arali

Try With this Expression

[lrtetala (Lakshman Reddy)]

Hi @shruthi_arali

Try this

(?<=TOTAL\sAMOUNT\s\(INCL.\sTAX\)\s).*

[Mohammed_Ismail_Rahid]

(Text.RegularExpressions.Regex.Matches(str,“(?<=Total Amount.*\s)\d+.+\d+”))(0).ToString
Try it

[tazunnisa.badavide (Taj)]

(?<=[A-Z]+\s*([A-Z]+.\s*[A-Z]+)\s*)\d+.\d+

Hey!Can u try it with this Regex Pattern