Text to Columns Single Row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all, am cleaning up a .txt file (attached sample). I input the data as a Delimited file with no deliminators, and started he data import on line 5.
here are my blocks.
The first row of data is unique, because it has the column headers separated by commas, but the subsequent data is deliminated by tabs. Ultimately, i want the first row of data to be my field names, but i cant seem to get there with using mulitple text to column tools, and the dynamic rename
is there a way to split just one row by commas, and the rest by tabs?
In addition, at the bottom of this report are Totals and Subtotals that i would also mike to remove
Thank you
Solved! Go to Solution.
- Labels:
- Datasets
- Input
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To remove the last two rows you can use a filter tool on [Group Name] with formula
!Contains([Group Name], @'Grand Total')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you, that worked great!
