I have converted data written on excel sheet in unix through shell & perl prg
now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this:

hfgg|tytt|

but I want like this:

||hfgg|tytt|

two pipe sign for two blank columns in excel sheet.

Probably when you're doing the conversion you can specify pattern to be added, logic rule like : in the beginning of every line insert " | "

hey,

Simple use awk to create excel files...as

awk '{print $1","$2","$3}' < /tmp/file.txt > /tmp/file.csv

No such delimiters would come !
Thanks !!