Parse (delimited string) key-value pairs in a column into separate lines

Hi experts,

e.g.

i/p data looks like

0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747,9700005405717924,9700005405733788|unidentified,unidentified,unidentified||

o/p data should like -

row1: 0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747|unidentified

row2:0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405717924|unidentified

row3:0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405733788|unidentified

I want to do it at the file level instead of in database. Any help will be greatly appreciated.

Thanks.
Suyog.

Why do you post the same problem twice? This is very irritating!

Try like:

$ awk 'BEGIN{FS=OFS="|"}; {n=split($3, A, ","); split($4, B, ","); for (i=1;i<=n; i++) print $1,$2,A,B}' file
0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405552747|unidentified
0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405717924|unidentified
0000xm7zcNDIkP888vRqGv93xA7:176n00qql||9700005405733788|unidentified