Save trailing empty cells in a tab delimited text file

  • Thread starter Thread starter osios
  • Start date Start date
O

osios

Hi,

I have a tab delimited text file which contains some empty values i
some of the cells, and some of the lines have empty cells at the end o
the line. In my original file (outputted by some software) empty cell
at the end of the line are represnted by a number of '\t' character
with empty strings in between.

When I open the file to edit it in excel and then resave it, empt
cells at the end of a line are not saved.

An example:
If this is the original line string (spaces are not part of the strin
- they just seperate chracters here, for clarity):

1 \t 2 \t \t \t \n

Excel will save it as:

1 \t 2 \n


I need the file saved in the first format of the example rather then i
the second format outputted by excel in order to continue processing i
in other software. Any way to do it, if I know in advance how man
columns I need in each line
 
Hi,

You could put $$4$$ in the next empty column, edit the output file in
Notepad and Replace All ,$$4$$ with nothing.

Hope this helps

--
 
Back
Top