Extract Data from Text file into excel file

Help StudioX
1

Hi, i am wondering if anyone can help me to extract the data from this text file into the attached excel template. The data that i require is on the information on each tracking number line. I tried to extract the data using the read text file but due to the difficult format of the text file i cannot get the data to read into a data table correctly.

image
image1201×388 12.7 KB

The excel file would just have columns for the Tracking number, Recipient/street, City, Reference and the amount per line.

Thanks for the any support.

2

Hi @gtones

You can try with Extract DataTable from Text activity Or by using Regex we can write it to datatable

Regards,

3

You can try to read a file as CSV and write it in excel. Then can remove unwanted rows

4

Hi @gtones ,

There are a few methods that you can try,

  1. Using Generate Data table activity
  2. Using Read CSV Activity
  3. Using Regular Expressions (Regex) and String Manipulation
  4. Using VB Script

You can try these methods and choose the one that best suits your use case. The exact solution can only be provided if the text file is available for analysis, as it is dependent on the file’s structure and content.