This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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