I am using ParseExcel for genrating excel data in unix. I have seprated the field using pipe "|" sign and I want that when ever the starting columns of the excel sheet are blank in that case it should be replaced by the pipe sign.
But its not working desirably means when ever the first columns of the excel sheet is empty it doesnot replace it with the pipe sign.
for example:
it currently showing is:

abc|abc|abc|
xyz|xyz|xyz|

and the desired output is:

||abc|abc|abc|
||xyz|xyz|xyz|

two pipe sign in starting for first two blank columns of the excel sheet.

it replaces the blank columns with pipe sign if they appear between the fields. But doesnot replace with the starting columns.