I am trying to parse data on two delimiters

Question

So what I'm trying to do is for this: looking at the example CSV:

1,3917,3917,BGP=694|Ethernet=1610|LAG=3,Y

After the script is run, the output should look similar to:

1,3917,3917,BGP=694,Y
1,3917,3917,Ethernet=1610,Y
1,3917,3917,LAG=3,Y

One line of original CSV file that contained additional delimiters is now converted into 3 lines because there were three additional fields within the 4th column.

I've been working on it all day and this is what I've come up with. Will it work?

Code:

 #!/usr/bin/ksh
   if [ $# -ne 1 ];
     then echo "Usage: read.sh filename";
     exit 1;
    fi
   file="$1"
   while read line
     do
       IFS='|'
       set x $line
       while [ a -le #$]
         do
           a=a+1
           echo "`$1`,`$a`"
         done
     done < $1

Answer 1

Use AWK Instead

This problem is much easier to solve with AWK. I tested this with GNU AWK; if you're using something else, you may need to tweak it a bit.

#!/usr/bin/gawk -f

BEGIN { FS = "|" }

{
  split( $3, array, /,/ )
  print $1 "," array[2]
  print $1 "," $2 "," array[2]
  print $1 "," $3
}

Store the script somewhere (e.g. parse.awk) and make sure it's executable. You can then call the script on a CSV file or on standard input, and collect your results like this:

$ echo '1,3917,3917,BGP=694|Ethernet=1610|LAG=3,Y' | parse.awk
1,3917,3917,BGP=694,Y
1,3917,3917,BGP=694,Ethernet=1610,Y
1,3917,3917,BGP=694,LAG=3,Y