Hi All, I need one help for formatting data in text file. Can anyone help me plz. It's urgent

Help Studio
, ,
1

2.txt (9.3 KB)
In Attached text file i have required data in it but every time columns are repeating. So instead of that is it possible to write data in below format’s

image
image1378×149 7.76 KB

image
image770×89 2.44 KB

Can anyone help me plz with this.

2

You won’t be reformatting the existing text file.

The approach woul be:

  • read the data as is.
  • split it into 2 halves, since you have 2 data type structures in 1 file
  • Transform the loose text to a datatable (2x)
  • Write the datatable back to the text file.

Since your example shows a tab-based layout, you should export it to .csv format using tab as a separator. since both .csv and .txt are text mime types they are interchangeable, but the export to csv activities will apply the correct separators and thus spacing for you.

After you’ve exported both tables to a file, join the 2 files into one.

3

Sorry, I didn’t got it clearly. Using UiPath activities how can I do it.