How to extract certain Text When it's getting distorted after using the read PDF text Activity

[Ishan_Shelke]

I am using Read PDF text to convert the text inside a PDF the PDF looks like this

After Extracting the text to PDF the text is getting distorted like this :

Now I need the Date which is mentioned in front of the GRN Date which in this case is :

Any Ideas on What Regex expression can be applied over this ?

Attaching the text file which contains the text after extracting from the PDF file for reference :
test.txt (139 Bytes)

[AkshaySandhu (AkshaySingh Sandhu)]

Can you please upload a sample PDF as well. It seems when one field is having blank value then its get replace by next one. eg. After RMS PO No. (10240290) there supposed be a blank line but its not there.

[Ishan_Shelke]

Can’t attach the full PDF that’s confidential Sorry and about the replacement the values are not getting replaced, Those are blank only

[Yoichi]

Hi,

Can you share settings of PreserveFormatting in ReadPDFText?

If it’s blank or False now, can you also share text in case set true?

Regards,

[Ishan_Shelke]

Keeping the Preserved Data option tIcked I got the output like this

[Yoichi]

Hi,

In this case, we can easily get each value using regex.
Can you share text file of this?

Regards,

[Ishan_Shelke]

Sure @Yoichi

Here you go -

test.txt (194 Bytes)

[karthickrkumaran (Karthick kumaran)]

Hi @Ishan_Shelke ,
Kindly find the screenshot for your solution,

[Yoichi]

HI,

Can you try the following sample?

System.Text.RegularExpressions.Regex.Match(strText,"(?<=GRN\s+Date\s+:\s+)\w.*").Value

Sample20230623-2L.zip (2.7 KB)

Regards,