Feb 7, 2010 #1 stu78 Programmer May 29, 2002 121 GB Hi, I have some data to split; the delimiter will always be ! so I just need to format e.g. test1!test2!test3! into test1! test2! test3!
Hi, I have some data to split; the delimiter will always be ! so I just need to format e.g. test1!test2!test3! into test1! test2! test3!
Feb 7, 2010 1 #2 PHV MIS Nov 8, 2002 53,708 FR A starting point: Code: awk '{x=$0;gsub(/!/,"!\n",x);printf "%s",x}' /path/to/input >output Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
A starting point: Code: awk '{x=$0;gsub(/!/,"!\n",x);printf "%s",x}' /path/to/input >output Hope This Helps, PH. FAQ219-2884 FAQ181-2886