replace any character with CR

[Stoicho Valkov]

I have a file like:
123;456;789
how can i replace ";" with carrige return or new line and result should be like:
123
456
789
Can i use sed or other simple command? And how?

[curt larson_1 · Accepted solution]

cat $file | tr ";" "\012" > $newfile

[T G Manikandan]

#cat |tr -s ";" "\n" >/tmp/

[Sergejs Svitnevs]

---oldfile---
123;456;789

Try to execute this command:
# sed 's/;/#/g' oldfile | tr '#' '\012' >newfile

Result:
---newfile---
123
456
789

Regards,
Sergejs

[Umapathy S]

You can also do it in vi.
open vi and the type in command line
:%s:;:^M:g
Where ^M is Ctrl+V, Ctrl+M.

HTH,
Umapathy

[Brian Bergstrand]

Or perl

cat | perl -pi -e "s/;/\n/go"

HTH.

[Steven Sim Kok Leong]

Hi,

Just for kicks, here's another way if you don't wish to use any of "\n" or "\012":

# for i in `sed 's/;/ /g' file`;do echo $i;done > parsed_file

Hope this helps. Regards.

Steven Sim Kok Leong