Converting text file into Datatable accumulating values in single column

[Rajna (Rajeswari)]

Hi All,

I am having a text file with below values

Codes 01052 01250 18050 08060
PP 11232 12093 19193 18422

and trying to convert it to datatable using generate datatable activity after replacing space with “:” as delimiter, gives all values in single column rather five columns.
Please need your suggestion

[Anil_G (Anil Gorthi)]

@Rajna

Did you use column delimiter as : in the generate datatable…looks like you did not

Cheers

[rlgandu (Rajyalakshmi Gandu)]

@Rajna

Try this hope it helps

[vrdabberu (Varunraj Dabberu)]

Hi @Rajna

→ Read Text File

Output-> str_Text
→ Generate DataTable from Text
Open the wizard and give the below specifications:

Output-> Dt_Result
→ Write Range Workbook Dt_Result. Do not enable Add Headers Option

Try this. This will work.

Main.xaml (11.9 KB)

Regards