AWK Scripting Loop

[gaka1108]

I have file like this:

root:x:0::192.168.164.164
bin:x:1:bin,daemon:192.168.164.164
daemon:x:2:bin,daemon:192.168.164.164

I wish to have a script which transforms the above into:

root;0;;192.168.164.164
bin;1;bin;192.168.164.164
bin;1;daemon;192.168.164.164
daemon;2;bin;192.168.164.164
daemon;2;daemon;192.168.164.164

 

[johnherman]

It looks like you want to use : as your FS, Field Separator and are only interested in $1,$3, and $5 and you want to create multiple records when $4 is parsed by comma. Is that a correct interpretation of the requirements?


==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[gaka1108]

Yes, that is correct.

 

[johnherman]

what have you tried so far?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[johnherman]

Here's a little something to get you started (untested)

awk FS=: '{if (index($4,")>0) print $1 $2 substr($4,1,index($4,",")-1) substr($4,index($0,",")) $5; else print $1 $2 $4 $5;}' /path/to/inputfile > /path/to/outputfile

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity