I have a file that uses
| as a delimiter. Some of the records have empty cell as
|| (nothing inside). I am trying to replace them with
|""| with following sed command:
sed -i 's/\|\|/\|""|/g' file
But the result wasn't what I expected.
Note that the beginning and ending of records doesn't have "|"
Any help would be appreciated.