Join a group of lines that are sperated by a blank line 1

[buckpasser]

Folks,

I would like to join a group of lines that are seperated by a blank line, so that the data continues to be coma delimited.

===============input============================

1st
8.0F,Dirt,Md Sp Wt,$42000,3UPyo

7
Bonanza Two,Gomez,Sadler
3.50
49.9
159.5
34.5
16.4
51.1
17.5
328.8
Y
Y
-1

4
Cat On the Run,Desormeaux,Drysdale
4.00
56.0
109.2
51.8
10.9
47.0
15.3
290.2
N
N
-1

8
Beneath the Radar,Solis,Headley
2.50
44.9
100.8
29.7
10.4
58.2
24.5
268.4
Y
N
0

3
Fremont,Court,McCarthy
3.00
46.6
97.7
25.0
14.2
42.2
20.4
246.1
N
N
0

2
Seattle Buddy,Cohen,Harty
5.00
51.2
77.8
13.3
9.0
44.0
12.2
207.6
Y
N
-1

5
Fuseout,Martinez,Angulo
30.00
41.1
78.4
12.4
5.0
7.4
2.0
146.4
N
N
1

1
Mino Ona ,Figueroa,Reviriego
30.00
44.3
32.1
40.1
0.7
22.3
2.0
141.6
Y
N
1

6
North America,Espinoza,Marlow
10.00
0.5
0.7
6.7
0.0
27.8
6.1
41.7
Y
N
na

2nd
6.0F,Dirt,Clm 20000,$21000,3yo

8
Eden Simone,Pedroza,Carava
5.00
95.1
68.1
22.3
13.8
25.1
11.7
236.2
N
N
0

4
Breezing Home,Vergara,Duncan
5.00
110.5
46.4
28.4
9.0
13.1
11.7
219.0
Y
N
8

6
Charlies Dot,Ochoa,Polanco
4.00
76.5
54.0
20.5
5.3
16.3
14.6
187.1
Y
N
-8

1
Seeking the Heat,Martinez,Craigmyle
6.00
68.4
71.1
16.4
5.7
7.2
9.7
178.5
Y
N
0

1A
Shirley Jean,Court,Craigmyle
6.00
75.5
46.9
19.8
7.4
14.0
9.7
173.4
Y
N
3

2
Spy Aly,Cohen,Sadler
8.00
71.3
54.1
15.7
6.3
18.2
7.3
172.9
Y
N
-1

7
Ivy League Miss,Espinoza,Peery
3.00
62.3
52.6
12.7
5.5
18.2
19.4
170.7
Y
N
3

3
Delightful Doris,Delgadillo,Barr
20.00
61.0
48.3
14.4
10.0
27.4
2.9
164.1
N
N
-1

5
Elkton,John,Cecil
4.50
59.5
39.6
9.8
3.7
20.4
13.0
146.0
N
N
2

============================output==================

1st,8.0F,Dirt,Md Sp Wt,$42000,3UPyo,

7,Bonanza Two,Gomez,Sadler,3.50,49.9,159.5,34.5,16.4,51.1,17.5,328.8,Y,Y,-1

4,Cat On the Run,Desormeaux,Drysdale,4.00,56.0,109.2,51.8,10.9,47.0,15.3,290.2,N,N,-1

8,Beneath the Radar,Solis,Headley,2.50,44.9,100.8,29.7,10.4,58.2,24.5,268.4,Y,N,0

3,Fremont,Court,McCarthy,3.00,46.6,97.7,25.0,14.2,42.2,20.4,246.1,N,N,0

2,Seattle Buddy,Cohen,Harty,5.00,51.2,77.8,13.3,9.0,44.0,12.2,207.6,Y,N,-1

5,Fuseout,Martinez,Angulo,30.00,41.1,78.4,12.4,5.0,7.4,2.0,146.4,N,N,1,

1,Mino Ona ,Figueroa,Reviriego,30.00,44.3,32.1,40.1,0.7,22.3,2.0,141.6,Y,N,1

6,North America,Espinoza,Marlow,10.00,0.5,0.7,6.7,0.0,27.8,6.1,41.7,Y,N,na

2nd,6.0F,Dirt,Clm 20000,$21000,3yo,

8,Eden Simone,Pedroza,Carava,5.00,95.1,68.1,22.3,13.8,25.1,11.7,236.2,N,N,0

4,Breezing Home,Vergara,Duncan,5.00,110.5,46.4,28.4,9.0,13.1,11.7,219.0,Y,N,8

6,Charlies Dot,Ochoa,Polanco,4.00,76.5,54.0,20.5,5.3,16.3,14.6,187.1,Y,N,-8

1,Seeking the Heat,Martinez,Craigmyle,6.00,68.4,71.1,16.4,5.7,7.2,9.7,178.5,Y,N,0

1A,Shirley Jean,Court,Craigmyle,6.00,75.5,46.9,19.8,7.4,14.0,9.7,173.4,Y,N,3

2,Spy Aly,Cohen,Sadler,8.00,71.3,54.1,15.7,6.3,18.2,7.3,172.9,Y,N,-1

7,Ivy League Miss,Espinoza,Peery,3.00,62.3,52.6,12.7,5.5,18.2,19.4,170.7,Y,N,3

3,Delightful Doris,Delgadillo,Barr,20.00,61.0,48.3,14.4,10.0,27.4,2.9,164.1,N,N,-1

5,Elkton,John,Cecil,4.50,59.5,39.6,9.8,3.7,20.4,13.0,146.0,N,N,2

 

[PHV]

A starting point:
awk '{if(NF)x=x","$0;else{print substr(x,2);x=""}}' input > output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[buckpasser]

PHV,

Thanks, worked great!

 

[buckpasser]

PHV,

I would like to place that command line into a script called join-grp.awk.

What would the script look like.

Thanks
Buckpasser

 

[PHV]

{
if(NF)
x=x","$0
else {
print substr(x,2)
x=""
}
}

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[buckpasser]

PHV,

Thanks for the script. Worked great.

Thanks again.