Split with " " file .txt to excel

Help
1

Hello

How i can separate the next .txt to excel in columns??

COL IND BROADWAY SECC 111 N
1018866800 7,999.00
DESC X PROM % 25.00 1,999.75-
COJIN SUEDE DISEÑ SECC 108 N
0049078757 359.00
DESC X PROM % 25.00 89.75-
COLUMPIO BARRO 90 SECC 116 N
0050662314 215.00
DESC X PROM % 25.00 53.75-

***** TOTAL $ 6,429.75

Liv1
Liv11220×422 44 KB

this is the .txt next, i have the DT in the for each , but I want the next result in the excel

A3 B3 C3
1018866800 7,999.00 1,999.75-

Thanks

2

Hi.

If you want to separate it by the space, you can probably just use a .Replace and change the character to a comma, then Write it to a CSV file with Write Text File activity.

Write Text File
   path: "filename.CSV"
   string: textstring.Replace(" ",",")
Read CSV to data table

However, it gets more complicated if some of the columns contain a space that you want to keep, or if you need to combine some rows to the same line.

Regards.

4

would you please share your .xaml file?