SOLVED
Converting TXT to Excel (Column Headers)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tj3678
7 - Meteor
‎10-28-2019
10:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Workflow
2 REPLIES 2
benakesh
12 - Quasar
‎10-28-2019
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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 .
‎10-28-2019
10:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks!
