Regex Based Extraction

[Ishan_Shelke]

Hi team Need to extract the Red highlighted value from the PDF

Please find the PDF Below

Jun-23.pdf (137.3 KB)

[B_H_Akshatha_Pai]

Regards,

[Ishan_Shelke]

The Value you have highlighted is not the correcct One the one whch I need according to the PDF is 53,25,000.00 which is just below the value which you have highlighted

[tazunnisa.badavide (Taj)]

@Ishan_Shelke
-------->output

regex pattern—>(?<=June-23\s+Al\s+)[0-9,.]+

here is the xaml
Main.xaml (8.9 KB)

[B_H_Akshatha_Pai]

My bad , here is the regex

Regards

[Ishan_Shelke]

This isn’t reliable the Month factor which you have used, the month keeps on changing in my case

[Ishan_Shelke]

Hi The value factor which you have used here isn’t reliable also. The values too keep on changing

[tazunnisa.badavide (Taj)]

hey!
can u try with this regex pattern

(?<=(Total:\s+)[A-Za-z0-9\s.]+)\d{1,},\d{1,},\d{1,}.\d{1,}

can also try with this :(?<=(Total:\s+)[A-Za-z0-9\s.])\d{1,},[0-9.,]

I tried keeping Total as the base since u need the total value

[Ishan_Shelke]

Can you explain what activity you are using so that your Text is getting extracted like this ? And what package version you are using ? Because When I am using Read PDF text mine is getting extracted like this. Can you help me in getting the same value from this text file ?

sample.txt (4.3 KB)

[Praveen_Mudhiraj]

Hi @Ishan_Shelke

You can try this Regex expression for total

str_InPut=“YourText”

System.Text.RegularExpressions.Regex.Split(str_InPut.Split({“Invoice Value”},StringSplitOptions.RemoveEmptyEntries)(0).Trim.Split({vblf},StringSplitOptions.RemoveEmptyEntries).Last.ToString.Trim,“\s.*”)(0)

for reference you can see the output

[tazunnisa.badavide (Taj)]

@tazunnisa.badavide

[A-Za-z0-9\s.]+)\d{1,},\d{1,},\d{1,}.\d{1,}

Okey I have considered your sample text as input

Try with this regex now:(?<=(Line Total:)[\s\S]+)(\d{1,},\d{1,},\d{1,}.\d{1,})(?=\s+(\d{1,},\d{1,},\d{1,}.\d{1,}))

Let me know if it works