UNIX for Dummies Questions & Answers

1|2||3|4|5||6

1|2|3|4|5|6

awk '{for(i=1; i<=NF; i++) if($i ~//) $i=$(i+1)}' input

2||3|4|5||6

awk -F"|" '{for(i=1;i<=NF;i++) {if($i != "") print $i"|";}}' input

sed 's:||:|:g' input

awk '{for(i=1; i<=NF; i++) if($i=="") for(j=i;j<=NF;j++)$j=$(j+1)}1' FS=\| OFS=\| infile

1|2|3|4|5|6||

awk '{for(i=1; i<=NF; i++) if($i=="") for(j=i;j<=NF;j++)$j=$(j+1);NF-=2}1' FS=\| OFS=\| infile

1|2|3|4|5|6

awk '{gsub(/^\||\|$/,x);gsub(/\|\|/,"|")}1' infile

1|2|3|4|5|6

sed 's/^|//;s/|$//;s/||/|/g' infile

awk '{gsub(/^\||\|$/,x);gsub(/\|\|/,"|")}1' infile

#!/usr/bin/gawk -f

BEGIN{FS=OFS="|"}

{
   <do my stuff 1>
}

# need to remove empty fields at this stage

{
    awk '{gsub(/^\||\|$/,x);gsub(/\|\|/,"|")}1' infile
}

# need to keep going with FS=OFS="|"

{
   <do my stuff 2>
}
1