create new lines 2

[jdhahbi]

Hi
I would like to add new lines with the strings after the comma.
The lines in the inFile have 2 fields separated by a tab.
I would like to remove the comma from the 2d fileld and add a new line where the 1st filed is empty and the 2d field is made of the string that followed the comma.

inFile
A[tab]m,n
B[tab]x,y,z
C[tab]t,r


outFile
A[tab]m
[tab]n
B[tab]x
[tab]y
[tab]z
C[tab]t
[tab]r


Thank you for helping
Joseph

 

[PHV]

What have you tried and where in your code are you stuck ?
Tip: have a look at the split function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[blarneyme]

tmp# cat txt
A  m,n
B  x,y,z
C  t,r

tmp# cat txt | awk '{gsub(",","\n");print}' |sed 's/^[a-z]/   &/'
A  m
   n
B  x
   y
   z
C  t
   r

 

[PHV]

blarneyme, why not simply this ?

awk '{gsub(",","\n   ");print}' txt

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[blarneyme]

When I tried it without using sed the output was

# awk '{gsub(",","\n");print}' txt
A m
n
B x
y
z
C t
r

Wasn't sure if the lines after the commas were supposed to be indented or not, so added the pipe to indent.

 

[blarneyme]

After looking at your post again, I see the spaces you added in awk after the newline which I didn't catch before!

 

[jdhahbi]

thank you everybody. It was very helpful.
I added a tab to get the format I want
awk '{gsub(",","\n\t");print}' inFile.txt
A m
[tab]n
B x
[tab]y
[tab]z
C t
[tab]r


joseph

 

[jdhahbi]

how can I get the reverse format?
For the lines that have the same first field, I want to reduce them to one line having the second field strings separated by a comma.

inFile

A[tab]x
B[tab]y
B[tab]z
C[tab]r
C[tab]s
C[tab]t
D[tab]q

outFile

A[tab]x
B[tab]y,z
C[tab]r,s,t
D[tab]q

thank you
joseph

 

[PHV]

Like this ?

awk 'function brk(){if(NR>1)print k"\t"substr(x,2);x="";k=$1}k!=$1{brk()}{x=x","$2}END{brk()}' inFile >outFile

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jdhahbi]

thank you so much, PHV