Print in next line after coma


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Print in next line after coma
# 1  
Old 02-17-2015
Print in next line after coma

Hi,

I have a file like seen below.

Code:
apple, orange, grapes
pineapple
tomato, potato
egg

I need a output like

Code:
apple
orange
grapes
pineapple
tomato
potato
egg

Please help.
# 2  
Old 02-17-2015
Hello jayadanabalan,

Following may help you in same for provided input.
Code:
awk '{gsub(/, /,"\n",$0);} 1'  Input_file

Output will be as follows.
Code:
apple
orange
grapes
pineapple
tomato
potato
egg

Thanks,
R. Singh
# 3  
Old 02-17-2015
Code:
$ cat infile
apple, orange, grapes
pineapple
tomato, potato
egg

Code:
$ awk  '1' RS=",|, " infile
apple
orange
grapes
pineapple
tomato
potato
egg

Code:
$ awk  '{$1=$1}1' FS=",|, "  OFS="\n" infile
apple
orange
grapes
pineapple
tomato
potato
egg

# 4  
Old 02-17-2015
Note: RS may only contain a regex in gawk and mawk. In regular awk only the first character is used.
# 5  
Old 02-17-2015
Although the -s (squeeze) option is said to work on the input set only, this seems to work:
Code:
tr -s ', ' '\n' < file

This User Gave Thanks to RudiC For This Post:
# 6  
Old 02-17-2015
My choice would be sed, but the 'tr -s' solution is neat if you have it.
Code:
sed '
  s/, */\
/g
 ' in_file >out_file

# 7  
Old 02-17-2015
Quote:
Originally Posted by RudiC
Although the -s (squeeze) option is said to work on the input set only, this seems to work:
Code:
tr -s ', ' '\n' < file

Nice, it needs a small adaptation for it to work on all systems (for example HP-UX, AIX):
Code:
tr -s ', ' '[\n*]' < file

or
Code:
tr -s ', ' '\n\n' < file


---
-s does not only work on the input set:
Quote:
When the -s option is specified, after any deletions or translations have taken place, repeated sequences of the same character shall be replaced by one occurrence of the same character
tr: Extended Description
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Reading a file line by line and print required lines based on pattern

Hi All, i want to write a shell script read below file line by line and want to exclude the lines which contains empty value for MOUNTPOINT field. i am using centos 7 Operating system. want to read below file. # cat /tmp/d5 NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root"... (4 Replies)
Discussion started by: balu1234
4 Replies

2. Shell Programming and Scripting

Find line then evaluate text on next line, print when condition is met

Hello, I am looking for a specific situation in a text file. The conditions are, > <CompoundName> InChI=1S/C5H12NO2/c1-5(2)4-8-6(3)7/h5H,4H2,1-3H3/q+1 I am looking for cases where the line "> <CompoundName>" is followed by a line that contains the string "InChI=" without regard to... (5 Replies)
Discussion started by: LMHmedchem
5 Replies

3. UNIX for Beginners Questions & Answers

Output to file print as single line, not separate line

example of problem: when I echo "$e" >> /home/cogiz/file.txt result prints to file as:AA BB CC I need it to save to file as this:AA BB CC I know it's probably something really simple but any help would be greatly appreciated. Thank You. Cogiz (7 Replies)
Discussion started by: cogiz
7 Replies

4. Shell Programming and Scripting

How to print previous line of multiple pattern matched line?

Hello, I have below format log file, Comparing csv_converted_files/2201/9747.1012H67126.5077292103609547345.csv and csv_converted_files/22019/97447.1012H67126.5077292103609547345.csv Comparing csv_converted_files/2559/9447.1012H67126.5077292103609547345.csv and... (6 Replies)
Discussion started by: arvindshukla81
6 Replies

5. Shell Programming and Scripting

Echo printing a line in 2 lines; expected to print in one line

Dear All, fileName: therm.txt nc3h7o2h 7/27/98 thermc 3h 8o 2 0g 300.000 5000.000 1390.000 41 1.47017550e+01 1.71731699e-02-5.91205329e-06 9.21842570e-10-5.36438880e-14 2 -2.99988556e+04-4.93387892e+01 2.34710908e+00 4.34517484e-02-2.65357553e-05 3 ... (7 Replies)
Discussion started by: linuxUser_
7 Replies

6. Shell Programming and Scripting

Print pipe separated list as line by line in Korn Shell

Korn Shell in AIX 6.1 I want to print the below shown pipe (|) separated list line by line. line=es349889|nhb882309|ts00293|snh03524|bg578835|bg37900|rnh00297|py882201|sg175883 for i in line do echo "Hello $line " done I wanted to execute the above for loop. But i can't even set the... (3 Replies)
Discussion started by: polavan
3 Replies

7. Shell Programming and Scripting

read file line by line print column wise

I have a .csv file which is seperated with (;) inputfile --------- ZZZZ;AAAA;BBB;CCCC;DDD;EEE; YYYY;BBBB;CCC;DDDD;EEE;FFF; ... ... reading file line by line till end of file. while reading each line output format should be . i need to print only specific columns let say 5th... (2 Replies)
Discussion started by: rocking77
2 Replies

8. Shell Programming and Scripting

Compare multiple fields in file1 to file2 and print line and next line

Hello, I have two files that I need to compare and print out the line from file2 that has the first 6 fields matching the first 6 fields in file1. Complicating this are the following restrictions 1. file1 is only a few thousand lines at most and file2 is greater than 2 million 2. I need to... (7 Replies)
Discussion started by: gillesc_mac
7 Replies

9. Shell Programming and Scripting

difference between double inverted coma and single inverted comma

Whats the basic difference between double inverted comma and single inverted comma and no comma applied at all? Eg1 if Eg2 if iEg3 f (1 Reply)
Discussion started by: abhisekh_ban
1 Replies

10. Shell Programming and Scripting

Counting occurence of a coma

I have a .csv file that I would like to count on each line the occurences of the coma. Each line should have the same amount, but as an integrity check I would like to include in my script this count. What is the best way of doing this? (3 Replies)
Discussion started by: dbrundrett
3 Replies
Login or Register to Ask a Question