Screen Scraping Text Output how to sort and export data to excel

Help Studio
1

Hi,

Is there anyway for me to sort and export the .txt data to excel using the write range activity?
Will need to separate the data by columns but I am not sure how to do this in Ui Path.

Thanks,
data.txt (1.3 KB)

2

Hello @Edward_Tan ,

Here is a demo, but you would have to refine it for more accuracy. The idea is:

image
image1470×1450 223 KB

and the output is something like that (some refining is still needed on the input data)

image
image835×589 125 KB

However, a better way of extracting the data is by using the UiPath Extract Data functionality on the real data (not the .txt file)

Hope it helps!
Best regards,
Marius

3

Hello @Edward_Tan

You can use Generate Datatable or Text to column activity to achieve this. It will help to convert text to datatable and then you can use Sort Datatable activity to sort it. Then use Write Range activity.

Thanks