Generate DataTable - Specific data is not stored in correct column

[KahPou_Liew (smallpotato)]

abc.txt (74 Bytes)
By using generate data table, the content in text file was write into excel sheet like:

I wish the content in text file to be write into excel as:

[lakshman (Ganta lakshman)]

@KahPou_Liew

It looks like it did properly only. I guess you are using Tab as delimiter in Generate DataTable activity.

[KahPou_Liew (smallpotato)]

You are right. But this value has a tab in between, so I am looking for a way to store this data within a column rather than stored into different columns.

[lakshman (Ganta lakshman)]

@KahPou_Liew

You have to replace single space with empty value and then try once.

[KahPou_Liew (smallpotato)]

@lakshman
How can I do that?

[lakshman (Ganta lakshman)]

@KahPou_Liew

Use Read Text File activity to read the data from file and will give you output as String. And then use Replace function to replace single space and then follow other steps as you did it earlier.

     newTxtData = txtData.Replace(" ","")

[KahPou_Liew (smallpotato)]

Not working. It will add an additional column as well: