I would like to write a script (probably AWK printf related) that will take my delimited file, remove some unwanted fields and add some additional fields througout the file:
For example:
1,4,fd,4r54,3,,4454
I want to keep fields 1,2,4,7 and add in two empty fields between fields 4 and 7 so the output would look like:
1,4,4r54,,,4454
Is this possible?