How to generate data table using text from a .tsv file?

[mishra.suraj (Suraj Mishra)]

Hello Everyone,

I have a .tsv file(not csv) and I want to convert this file to excel file. I tried doing it through rename file activity but I wasn’t as well as I tried doing it by first reading the .tsv file using Read Text File activity then I wanted to create a data table using generate data table activity. But challenge is that I am not able to generate a data table as I am not able to figure out a proper column separator. Please find the sample text below:

Class Type Number Apply Date Allocated Receipt Amount Currency Amount Applied Discount Total Activity Amount Line GL Date Chargeback Number Status State Comments Activity Date Created By Original Transaction Reference Original Transaction Reference Type Purchase Order

These all are the column names. Please do suggest a column separator here I can use to generate a data table. Any kind of help is appreciated.

Thanks

[Steven_McKeering]

Hi

Can you use the ‘Read CSV’ activity then use a System Write Range. This will save as an .xlsx.

Hopefully this helps.

Cheers

Steve

[Anil_G (Anil Gorthi)]

@mishra.suraj

You can still use read csv and select the delimter as tab and that should be working as expected

Cheers