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.
To remove the last two rows you can use a filter tool on [Group Name] with formula
!Contains([Group Name], @'Grand Total')
thank you, that worked great!