Split Text in textfile to Excel

Help
, , ,
1

We have data in textfile and we want to split with “|” and write it into excel file with proper data and we can not use build datatable because we have more than 300 columns.
test.txt (2.4 KB)

2

Did we try with Generate datatable activity with delimiter as pipe
@Gauri_Rawool

1 Like
3

Hi,

If you have your data as a file, you can directly read it to datatable using Read CSV activity as the following settings.
Then you can write the datatable to xlsx using Write Range Activity.

img20200106-3
img20200106-3898×478 16 KB

Regards,

4

yup but we dont have data in proper format in text file.

5

can u plz share a workflow.

6

Hi,

Can you change to “Pipe” at Delimiter property of READ CSV Activity?
It will work.

If there isn’t “Pipe” option , it might be needed to update UiPath Excel Activity Package

Regards,

7

Still not working. can you share your workflow.

8

Use Read Text File Save it in a Variable
Use Set To Clipboard and add this variable
Use Excel Application Scope
Then GoTo A1 by using goto function
Then use Ctrl+V
Then by using Record Macro do following steps and use this VBA code for invoke VBA
ALT+D+E
.
image
image
THEN next

9

Hi,

Hope this helps you.

Sample20200106.zip (11.0 KB)

Regards,

10

BUT IT IS NOT WORKING FOR THIS FILE.BAGI.txt (182.7 KB)

11

Hi,

BAGI.txt has 197 headers but has 198 data in each row.
So it causes exception in ReadCSV Activity.

If you cannot add a header or remove the last pipe in each lines, can you try the following sample for Generate DataTable Activity as workaround?

Sample20200107.zip (45.5 KB)

It won’t throw, but add new column header called “Column1”.

Regards,