Convert Text (.txt) file to Excel (.xlsx)

Question

Hello , How do I go about converting a text file with "~" delimiter to excel (.xlsx) ? I have tried using the data input tool but it has been giving me some weird results ... it is taking the the fields in the text file as a single and cannot seem to be able to recognize that there are 10 fields ... Thanks!

unknown · Accepted Answer

Choose a CSV file input option for your input tool and then in the delimiters area change the delimiter to ~ instead of a comma. Then output to Excel.

JoeS · Accepted Answer

HI @Daniel_Ajao,

As above, you will need to read your input file using the CSV option within the Input Data tool.

Then within the options you now have available, option number 5 is the delimiter character. update this from comma (,) to tilde (~)

You should then be able to read in your file with the 10 columns as expected.

Thanks

Joe