Regex after pdf conversion.

[sachinsg]

Hi all,

I converted a pdf and extracted the data which I need for further processing. Below is the dummy data which the replicates the same.

I am using Regex to format the data as required below.

Thanks in advance!

[sachinsg]

PLease use this input image and ignore the previous image.

[Jean-Balteryx]

Hi @sachinsg ,

Would you be able to send the data as file ?

Cheers,

Jean-Baptiste

[markcurry · Accepted solution]

Hi @sachinsg 

Sometimes with the data extracted from PDFs you can be lucky, and be able can use RegEx to replace 2 or more spaces with a | , then use Text to Columns to split by the |

See sample workflow, hopefully that helps.

[sachinsg]

Hi Jean-Balteryx,

Attached is the input file.

Thanks.