replacing comma's with newlines using sed Post: 302241155

Sponsored Content

Top Forums Shell Programming and Scripting replacing comma's with newlines using sed Post 302241155 by DeCoTwc on Sunday 28th of September 2008 02:48:11 PM

09-28-2008

Registered User

Quote:

Originally Posted by newbie_coder

Hi All,
silly question that I'm sure is easy to answer for a more experienced coder...

I have a file called test.txt containing the following text...

need, to, break, this, line, into, individual, lines

using sed, I'd like to make the file look like this...

need
to
break
this
line
into
individual
lines

here's the code I've tried

#!/bin/ksh
sed "s/,/\n/" test.txt > test.new.txt

but it returns the following in test.new.txt
Addn this, line, after, every, line, with, WORD

so, my questions are...
1.) how can I make sed replace all instances of "," in a given line?
2.) how can I make sed insert newline characters instead of just the character n?

Thanks in advance!

Code:

d@DeCobox-Micro ~
$ cat unix 
need, to, break, this, line, into, individual, lines

$ cat unix |sed 's/\,/\n/g'
need
 to
 break
 this
 line
 into
 individual
 lines

d@DeCobox-Micro ~
$ cat unix |tr "," "\n"
need
 to
 break
 this
 line
 into
 individual
 lines

d@DeCobox-Micro ~
$ cat unix |tr "," "\n" |tr -d "^ "
need
to
break
this
line
into
individual
lines

This User Gave Thanks to DeCoTwc For This Post:

DeCoTwc

View Public Profile for DeCoTwc

Find all posts by DeCoTwc

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing strings with newlines : sed

Hi everyone, Since the previous time I received help from unix.com I have been encouraged to learn more. going through 1 of the articles(View Article) on sed I found, it pointed an interesting situation. Suppose the text is : Romeo and Ethel the Dancer Moves Audience to Tears. I...

2. UNIX for Dummies Questions & Answers

Replacing Comma by Tab

Hi All, i have a file test.txt as shown below, 1,test,test111 2,rest,rest222 i want to replace the commas by tab delimiter.., it should be like, 1 test test111 2 rest rest222 i tried the following code, sed 's/,/\\t/g' test.txt >> ouptut.txt

3. Shell Programming and Scripting

Replacing dot for comma

I wanted to change 34.66 to 34,66. I tried the command: sed 's/./,/' $NUM Where $NUM is a variable with 34.66 value. The output is ,4.66

4. UNIX for Dummies Questions & Answers

adding symbol to newlines with out replacing them

Guyz I have been using tr command to replace symbol. I would like to add a symbol to all newlines in a textfile with out replacing them input \n (i mean new line) a \n b \n c output > a > b > c

5. Shell Programming and Scripting

sed help - replacing 6th comma with a space

Hi, How can I replace the 6th comma on each line (of a csv) with a space? Any online tutorials with plenty of examples using sed would be very useful. Alex

6. UNIX for Dummies Questions & Answers

Replacing | with a comma

I have a huge file which is pipe delimiter and i want to replace the pipe delimiter to a comma Please Help as its v urgent. Ex: parent|child|alias|....Heading of the file...and the data is of similar structure.

7. Shell Programming and Scripting

How to split the 11 comma's with number into newlines?

Hi all, This my requirement is to spilt the comma's into new line my sample is Name,india,ID,cost,Date,vadaloreOffset,neyveliCurveUnit,Riskcuddalore ,,,,,,,,,,,1,0.00576652,,,,,,,,,,,7,0.00625467,,,,,,,,,,,30,0.00832759,,,,,,,,,,,61,0.00977132 expected output to be like this...

8. Shell Programming and Scripting

Need help with Sed (replacing parenthesis and comma)

I have the following text as an input text: input.txt Results('Toilet', 'Sink', ) and i want to remove the last comma so the output is output.txt Results('Toilet', 'Sink' ) I tried using the following sed command, but I get a parsing error: sed s/, \)/\)/g input.txt >...

9. Shell Programming and Scripting

sed replacing required newlines

hi i have a requirement to replace a string with another using sed and to get the result newline separated but after sed replacement the newline vanishes below is sample code #!/bin/ksh set -x string="name sam\nage 45 \nsport soccer" echo $string string=`echo $string | sed...

LEARN ABOUT SUNOS

diffmk

diffmk(1)							   User Commands							 diffmk(1)

NAME

       diffmk - mark differences between versions of a troff input file

SYNOPSIS

       diffmk oldfile newfile markedfile

DESCRIPTION

       diffmk  compares  two versions of a file and creates a third version that includes "change mark" (.mc) commands for nroff(1) and  troff(1).
       oldfile and newfile are the old and new versions of the file. diffmk generates markedfile, which,  contains  the  text  from  newfile  with
       troff(1) "change mark" requests (.mc) inserted where  newfile differs from  oldfile. When markedfile is formatted, changed or inserted text
       is shown by  | at the right margin of each line. The position of deleted text is shown by a single *.

USAGE

       See largefile(5) for the description of the behavior of diffmk when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).

EXAMPLES

       Example 1: An example of the diffmk command.

       diffmk can also be used in conjunction with the proper  troff requests to produce program listings with marked changes.	In  the  following
       command line:

       example% diffmk old.c new.c marked.c ; nroff reqs marked.c | pr

       the file reqs contains the following troff requests:

       .pl 1
       .ll 77
       .nf
       .eo
       .nh

       which eliminate page breaks, adjust the line length, set no-fill mode, ignore escape characters, and turn off hyphenation, respectively.

       If the characters  | and * are inappropriate, you might run  markedfile through	sed(1) to globally change them.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWdoc			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       diff(1), nroff(1), sed(1), troff(1), attributes(5), largefile(5)

BUGS

       Aesthetic  considerations  may  dictate	manual	adjustment of some output. File differences involving only formatting requests may produce
       undesirable output, that is, replacing .sp by .sp 2 will produce a "change mark" on the preceding or following line of output.

SunOS 5.10							    14 Sep 1992 							 diffmk(1)