Txt file to Excel file

@eimon Check this workflow :
Regex Find.zip (7.5 KB)

I have kept some considerations in place for the workflow to work accordingly, The Conditions are :

  1. The Table is between the “Products List” and “Language”.
  2. There are only two Columns, and they are separated by a Space.

I have used String manipulations and Regex for getting the desired result. If you want to know more about regex, check the below Topic :

Also, I had noticed that in the original file, for one of the rows, there were no spaces between the date and the first word. Was it by mistake, or was was extracted from the PDF in that way?

Depending on this you may have to consider a different approach or a modification in the approach that I have provided.

2 Likes