Feb 1, 2016 #1 gaka1108 Technical User Joined Feb 1, 2016 Messages 5 Location GB Hi All, I have an input file in linux with the following entries: X:1,2,3,4 Y:5,6,7,8 ...and so on I require an output like below: X:1 X:2 X:3 X:4 Y:5 Y:6 Y:7 Y:8 Could someone please provide a solution to this? Regards, Gaurav
Hi All, I have an input file in linux with the following entries: X:1,2,3,4 Y:5,6,7,8 ...and so on I require an output like below: X:1 X:2 X:3 X:4 Y:5 Y:6 Y:7 Y:8 Could someone please provide a solution to this? Regards, Gaurav
Feb 1, 2016 1 #2 feherke Programmer Joined Aug 5, 2002 Messages 9,541 Location RO Hi Assuming there are no other colons ( : ) and commas ( , ) then the field delimiters : Code: master # awk -F '[:,]' '[teal]{[/teal][b]for[/b][teal]([/teal][navy]i[/navy][teal]=[/teal][purple]2[/purple][teal];[/teal][navy]i[/navy][teal]<=[/teal]NF[teal];[/teal][navy]i[/navy][teal]++)[/teal][b]print[/b][navy]$1[/navy][i][green]":"[/green][/i][navy]$i[/navy][teal]}[/teal]' /path/to/input X:1 X:2 X:3 X:4 Y:5 Y:6 Y:7 Y:8 Feherke. feherke.ga Upvote 0 Downvote
Hi Assuming there are no other colons ( : ) and commas ( , ) then the field delimiters : Code: master # awk -F '[:,]' '[teal]{[/teal][b]for[/b][teal]([/teal][navy]i[/navy][teal]=[/teal][purple]2[/purple][teal];[/teal][navy]i[/navy][teal]<=[/teal]NF[teal];[/teal][navy]i[/navy][teal]++)[/teal][b]print[/b][navy]$1[/navy][i][green]":"[/green][/i][navy]$i[/navy][teal]}[/teal]' /path/to/input X:1 X:2 X:3 X:4 Y:5 Y:6 Y:7 Y:8 Feherke. feherke.ga
Feb 1, 2016 Thread starter #3 gaka1108 Technical User Joined Feb 1, 2016 Messages 5 Location GB Super! Worked like a charm. Thank you so much! Upvote 0 Downvote