Hi all,
I am trying to convert a text file to excel using the 'Text to Columns' tool, but am unable to convert/keep the column headers as the tool only separates beginning on row 2 by delimiter. See example below:
Data input
Output below
Any help appreciated!
Solved! Go to Solution.
@tj3678 ,
Option 1:
Deselect first row contains field names and use dynamic rename to change headings (take field names from first row) .
Option 2:
I see you have \0 ( no delimiter) for delimiter . You can also use ';' as delimiter .
Thanks!