For the past few days I've been working on a large TSV file. I've created a script that turns the file into multiple .xls files. I've got one problem I can't seem to solve on my own so I'd much appreciate your help on this:
Some lines in TSV file contain no data in random tab separated boxes, so the txt file has a double tab in that place. My FOR /F loop that uses a tab as a delimiter then takes the next string it finds and offsets all the data from that point on (in that line).
What I need to do is add something to my script to replace <tab><tab> with <tab>something<tab>
Can you please help me do this? I've tried using double tab as a delimiter, using a find function and busted my head for many hours over this..
Thank you for your time and effort.