Replacing every 10th pipe with new line in unix
- by user327958
Lets say I have fields:
name, number, id
I have a data file:
name1|number1|id1|name2|number2|id2...etc
I want to replace every 3rd pipe with a new line or '\n' so I get:
name1|number1|id1
name2|number2|id2
I'm having no luck with awk or sed.
I've tried the following, and variations of:
awk '/"\|"/{c++;if(c==10){sub("\|","\n");c=0}}1'…