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:
It looks like it did properly only. I guess you are using Tab as delimiter in Generate DataTable activity.
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.
1 Like
You have to replace single space with empty value and then try once.
1 Like
@lakshman
How can I do that?
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(" ","")