buckpasser
Technical User
I need to join the first line/record in a group, ie. line beginning with 1st, 2nd, 3rd and up,(note: two fields)- to each of the lines/records below it. Fields are delimited by a ",".
Input looks like this:
=====================INPUT===============================
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,
5,Mysterious Cat (Piermarini) | Nunez,4-1,107.6,120.8,35.8,9.7,10.6,15.1,299.7,N,Y,0
3,Jammin J J (Valenzuela) | Glatt,2-1,106.3,65.8,30.3,20.3,44.1,30.3,297.1,N,N,3
4,Good Cop Bad Cop (Rivera) | Cardenas,4-1,109.8,88.7,24.4,9.3,22.6,15.1,269.9,Y,N,3
6,Award Winning Team (Gomez) | Carava,7-2,110.3,69.5,22.1,11.3,36.0,17.3,266.5,N,N,0
7,Devil's Money (Martinez) | Gonzalez,4-1,106.0,64.6,23.7,9.2,23.9,15.1,242.4,N,N,0
2,Proud Alvin (Jauregui) | Hernandez,15-1,89.7,31.7,11.0,6.2,22.9,4.0,165.4,Y,N,0
1,Danceascore (Castanon) | Olivarez,20-1,69.2,40.2,12.7,0.7,0.0,3.0,125.7,Y,N,1
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,
2,Ran for the Dough (Sorenson) | Gallagher,6-1,116.6,125.9,12.2,9.8,34.9,9.9,309.3,N,N,0
5,Princess Sequoia (Desormeaux) | Ellis,2-1,71.7,111.5,11.7,5.6,47.5,29.7,277.6,N,N,-4
4,Dolly Wells (ARG) (Espinoza) | De,3-1,81.1,97.4,18.6,11.9,44.4,19.8,273.2,N,N,0
1,Redmeansgo (Valenzuela) | Becerra,5-2,74.5,90.9,15.3,23.3,41.1,23.8,268.9,N,N,0
6,Brave Miss (Douglas) | Stute,12-1,65.3,110.6,7.6,7.0,38.1,5.0,233.6,N,N,-2
3,Sharpened Copy (Solis) | Headley,5-1,70.7,76.3,14.6,9.1,34.0,11.9,216.6,N,N,0
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,
4,West Coast Gee Gee (Nakatani) | Glatt,3-1,82.3,63.7,33.7,10.2,28.6,21.7,240.0,Y,N,-3
7,The Borg Queen (Valenzuela) | Dolan,4-1,60.1,76.6,46.3,6.0,33.2,16.2,238.4,N,N,-1
2,Kind Lena (Cohen) | Bernstein,6-1,74.7,71.3,32.2,7.1,23.2,10.8,219.3,Y,N,-8
1,Rozys Account (Court) | McCarthy,5-1,65.5,62.5,26.3,8.5,30.5,13.0,206.4,Y,N,4
8,Vegas Folly (Pedroza) | Carava,9-2,64.1,64.9,28.2,7.5,25.8,14.4,205.1,Y,N,-1
5,Dance of the Year (Atkinson) | Robbins,6-1,61.4,63.4,27.9,7.3,20.3,10.8,191.1,N,N,-4
3,La Chola (Espinoza) | Moreno,10-1,55.5,42.9,34.2,13.2,27.9,6.5,180.1,N,N,-3
6,Mysterious Peace (Martinez) | Dunham,10-1,56.5,36.0,37.8,6.9,10.5,6.5,154.2,N,N,-1
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,
3,Me Moe You Curly (Figueroa) | O'Neill,9-5,151.5,153.8,21.8,0.0,20.3,19.7,367.1,Y,Y,5
8,Dominated Girl (Valenzuela) | Periban,5-2,111.2,84.7,115.3,19.1,20.7,14.2,365.2,N,N,2
6,Anearlyfil (Urieta-Moran) | Stute,10-1,83.7,93.3,49.5,14.5,16.7,3.6,261.2,N,N,0
4,Suspicious Town (Berrio) | Avila,10-1,80.8,57.5,41.5,17.9,22.5,3.6,223.7,N,N,0
1,Memorly (Gomez) | Cerin,5-1,79.5,74.9,15.9,1.2,19.4,7.1,198.0,Y,Y,2
2,Tintinabulation (Court) | Shulman,5-1,84.8,57.2,18.4,14.0,13.3,7.1,194.8,N,N,0
5,Forgiving (Ochoa) | Moreno,15-1,87.4,46.1,21.8,0.0,29.9,2.4,187.6,Y,N,-9
7,Heavenly Valentine (Baze) | Glatt,15-1,1.0,1.3,9.2,0.0,17.2,2.4,31.0,Y,N,na
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,
2,Polyfirst (FR) (Douglas) | Mandella,9-5,124.3,94.2,30.6,27.0,34.8,32.7,343.6,N,N,0
4,Quatrain (Solis) | Sadler,5-2,112.7,83.4,29.1,0.9,30.8,23.5,280.4,Y,N,-3
5,Megec Blis (IRE) (Espinoza) | Cardenas,7-2,105.5,72.6,26.1,14.0,35.5,16.8,270.5,Y,N,0
3,Cousineau (Nakatani) | Dollase,8-1,105.7,94.3,19.7,10.5,27.2,7.4,264.6,Y,N,0
6,Fortunately (GB) (Valdivia) | Yakteen,6-1,115.1,63.6,21.9,12.4,20.4,9.8,243.2,Y,N,0
1,The Usual (Desormeaux) | Abrams,12-1,75.7,100.6,28.8,0.9,31.3,4.9,242.2,N,N,-4
7,Exclusive Danielle (GB (Court) | Shulman,12-1,1.2,16.4,30.4,0.9,20.0,4.9,73.8,Y,N,-3
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,
5,Beau (Court) | Hendricks,3-1,74.9,142.6,76.5,11.7,22.4,11.8,339.9,N,N,0
3,Spectacular Bay (Martinez) | DeLeon,9-2,61.0,108.9,59.5,9.7,15.1,7.9,262.1,N,N,0
6,Zeetop (Valenzuela) | Knapp,2-1,65.6,81.6,58.9,11.0,27.1,17.8,262.0,N,N,0
2,Virgo Genius (Baze) | Stute,15-1,65.6,74.5,36.0,7.0,23.6,2.4,209.0,N,N,0
8,Haven House (Smith) | Lewis,5-2,61.6,79.1,20.6,11.6,21.3,14.2,208.4,N,N,0
7,Swiss Alps (Baze) | Harrington,15-1,57.3,72.6,16.3,8.8,17.0,2.4,174.3,N,N,-2
1,He's My Bud (Cohen) | Mendoza,30-1,53.5,52.0,16.3,6.9,18.1,1.2,147.9,N,Y,-2
4,Inherent (Jauregui) | Mulhall,15-1,0.7,1.2,9.2,0.0,15.3,2.4,28.8,Y,N,na
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,
2,Drake's Victory (Valenzuela) | Canani,3-1,57.2,93.0,32.0,16.5,13.5,20.5,232.7,Y,N,0
1,Dr. Ramos (Douglas) | Cerin,2-1,72.9,32.5,34.8,13.9,22.7,30.8,207.6,N,N,-2
9,Rhythm King (Stevens) | Mandella,15-1,65.3,69.6,17.3,9.4,27.2,4.1,192.9,N,N,0
5,Colonial Reign (Nakatani) | Mandella,5-1,60.4,77.6,19.5,0.7,21.5,12.3,192.1,Y,N,2
3,Like a Tiger (Baze) | Greely,5-1,52.5,75.4,17.2,15.7,16.2,12.3,189.3,N,N,-2
6,Saint Chrisjon (Court) | Capestro,15-1,54.0,66.6,23.7,0.7,25.1,4.1,174.3,Y,N,4
4,Alwayswantmore (Espinoza) | Hendricks,15-1,59.1,62.0,13.4,8.3,22.2,4.1,169.1,Y,N,0
8,Fountain Grove (Gomez) | Capestro,15-1,58.1,44.1,23.1,0.7,26.6,4.1,156.7,Y,N,0
7,Fra Diavolo (ARG) (Solis) | Mandella,8-1,0.6,48.0,32.2,0.7,24.9,7.7,114.1,Y,N,-4
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,
4,Shoot for Gold (Gomez) | Duncan,3-1,73.5,76.3,105.8,15.4,16.6,21.9,309.6,Y,N,5
3,Taps for Liberty (Valdivia) | McAnally,4-1,73.5,78.8,18.5,0.0,12.8,16.4,200.0,Y,N,1
2,Proud Suzett (Martinez) | Gonzalez,6-1,81.0,44.3,36.4,9.6,8.9,10.9,191.1,N,N,0
7,Lass Lil' Sunrise (John) | Dutton,15-1,43.2,54.2,59.2,3.7,12.2,4.4,176.9,Y,N,0
10,Pavona (Steiner) | Kitchingman,9-2,58.2,50.4,13.7,8.8,16.2,14.6,161.9,Y,Y,0
5,Glory to the Top (Enriquez) | Dollase,12-1,61.7,49.2,16.2,11.1,15.7,5.5,159.4,N,N,-2
9,Bella Luchia (Gutierrez) | Aleman,15-1,64.1,47.0,15.1,9.9,7.0,4.4,147.5,Y,N,-2
6,She's a Bold Lady (Court) | Wilmot,20-1,63.1,35.6,13.7,8.2,7.4,3.3,131.3,N,N,0
1,Summer Jersey (Baze) | Yakteen,5-1,0.8,0.9,7.3,0.0,10.1,13.1,32.3,Y,N,na
8,Veela (Smith) | Vienna,12-1,0.8,0.9,7.3,0.0,13.0,5.5,27.5,Y,Y,na
===============OUTPUT==============================
I want the output to look like this:
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,5,Mysterious Cat (Piermarini) | Nunez,4-1,107.6,120.8,35.8,9.7,10.6,15.1,299.7,N,Y,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,3,Jammin J J (Valenzuela) | Glatt,2-1,106.3,65.8,30.3,20.3,44.1,30.3,297.1,N,N,3
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,4,Good Cop Bad Cop (Rivera) | Cardenas,4-1,109.8,88.7,24.4,9.3,22.6,15.1,269.9,Y,N,3
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,6,Award Winning Team (Gomez) | Carava,7-2,110.3,69.5,22.1,11.3,36.0,17.3,266.5,N,N,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,7,Devil's Money (Martinez) | Gonzalez,4-1,106.0,64.6,23.7,9.2,23.9,15.1,242.4,N,N,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,2,Proud Alvin (Jauregui) | Hernandez,15-1,89.7,31.7,11.0,6.2,22.9,4.0,165.4,Y,N,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,1,Danceascore (Castanon) | Olivarez,20-1,69.2,40.2,12.7,0.7,0.0,3.0,125.7,Y,N,1
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,2,Ran for the Dough (Sorenson) | Gallagher,6-1,116.6,125.9,12.2,9.8,34.9,9.9,309.3,N,N,0
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,5,Princess Sequoia (Desormeaux) | Ellis,2-1,71.7,111.5,11.7,5.6,47.5,29.7,277.6,N,N,-4
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,4,Dolly Wells (ARG) (Espinoza) | De,3-1,81.1,97.4,18.6,11.9,44.4,19.8,273.2,N,N,0
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,1,Redmeansgo (Valenzuela) | Becerra,5-2,74.5,90.9,15.3,23.3,41.1,23.8,268.9,N,N,0
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,6,Brave Miss (Douglas) | Stute,12-1,65.3,110.6,7.6,7.0,38.1,5.0,233.6,N,N,-2
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,3,Sharpened Copy (Solis) | Headley,5-1,70.7,76.3,14.6,9.1,34.0,11.9,216.6,N,N,0
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,4,West Coast Gee Gee (Nakatani) | Glatt,3-1,82.3,63.7,33.7,10.2,28.6,21.7,240.0,Y,N,-3
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,7,The Borg Queen (Valenzuela) | Dolan,4-1,60.1,76.6,46.3,6.0,33.2,16.2,238.4,N,N,-1
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,2,Kind Lena (Cohen) | Bernstein,6-1,74.7,71.3,32.2,7.1,23.2,10.8,219.3,Y,N,-8
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,1,Rozys Account (Court) | McCarthy,5-1,65.5,62.5,26.3,8.5,30.5,13.0,206.4,Y,N,4
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,8,Vegas Folly (Pedroza) | Carava,9-2,64.1,64.9,28.2,7.5,25.8,14.4,205.1,Y,N,-1
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,5,Dance of the Year (Atkinson) | Robbins,6-1,61.4,63.4,27.9,7.3,20.3,10.8,191.1,N,N,-4
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,3,La Chola (Espinoza) | Moreno,10-1,55.5,42.9,34.2,13.2,27.9,6.5,180.1,N,N,-3
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,6,Mysterious Peace (Martinez) | Dunham,10-1,56.5,36.0,37.8,6.9,10.5,6.5,154.2,N,N,-1
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,3,Me Moe You Curly (Figueroa) | O'Neill,9-5,151.5,153.8,21.8,0.0,20.3,19.7,367.1,Y,Y,5
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,8,Dominated Girl (Valenzuela) | Periban,5-2,111.2,84.7,115.3,19.1,20.7,14.2,365.2,N,N,2
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,6,Anearlyfil (Urieta-Moran) | Stute,10-1,83.7,93.3,49.5,14.5,16.7,3.6,261.2,N,N,0
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,4,Suspicious Town (Berrio) | Avila,10-1,80.8,57.5,41.5,17.9,22.5,3.6,223.7,N,N,0
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,1,Memorly (Gomez) | Cerin,5-1,79.5,74.9,15.9,1.2,19.4,7.1,198.0,Y,Y,2
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,2,Tintinabulation (Court) | Shulman,5-1,84.8,57.2,18.4,14.0,13.3,7.1,194.8,N,N,0
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,5,Forgiving (Ochoa) | Moreno,15-1,87.4,46.1,21.8,0.0,29.9,2.4,187.6,Y,N,-9
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,7,Heavenly Valentine (Baze) | Glatt,15-1,1.0,1.3,9.2,0.0,17.2,2.4,31.0,Y,N,na
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,2,Polyfirst (FR) (Douglas) | Mandella,9-5,124.3,94.2,30.6,27.0,34.8,32.7,343.6,N,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,4,Quatrain (Solis) | Sadler,5-2,112.7,83.4,29.1,0.9,30.8,23.5,280.4,Y,N,-3
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,5,Megec Blis (IRE) (Espinoza) | Cardenas,7-2,105.5,72.6,26.1,14.0,35.5,16.8,270.5,Y,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,3,Cousineau (Nakatani) | Dollase,8-1,105.7,94.3,19.7,10.5,27.2,7.4,264.6,Y,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,6,Fortunately (GB) (Valdivia) | Yakteen,6-1,115.1,63.6,21.9,12.4,20.4,9.8,243.2,Y,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,1,The Usual (Desormeaux) | Abrams,12-1,75.7,100.6,28.8,0.9,31.3,4.9,242.2,N,N,-4
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,7,Exclusive Danielle (GB (Court) | Shulman,12-1,1.2,16.4,30.4,0.9,20.0,4.9,73.8,Y,N,-3
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,5,Beau (Court) | Hendricks,3-1,74.9,142.6,76.5,11.7,22.4,11.8,339.9,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,3,Spectacular Bay (Martinez) | DeLeon,9-2,61.0,108.9,59.5,9.7,15.1,7.9,262.1,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,6,Zeetop (Valenzuela) | Knapp,2-1,65.6,81.6,58.9,11.0,27.1,17.8,262.0,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,2,Virgo Genius (Baze) | Stute,15-1,65.6,74.5,36.0,7.0,23.6,2.4,209.0,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,8,Haven House (Smith) | Lewis,5-2,61.6,79.1,20.6,11.6,21.3,14.2,208.4,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,7,Swiss Alps (Baze) | Harrington,15-1,57.3,72.6,16.3,8.8,17.0,2.4,174.3,N,N,-2
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,1,He's My Bud (Cohen) | Mendoza,30-1,53.5,52.0,16.3,6.9,18.1,1.2,147.9,N,Y,-2
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,4,Inherent (Jauregui) | Mulhall,15-1,0.7,1.2,9.2,0.0,15.3,2.4,28.8,Y,N,na
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,2,Drake's Victory (Valenzuela) | Canani,3-1,57.2,93.0,32.0,16.5,13.5,20.5,232.7,Y,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,1,Dr. Ramos (Douglas) | Cerin,2-1,72.9,32.5,34.8,13.9,22.7,30.8,207.6,N,N,-2
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,9,Rhythm King (Stevens) | Mandella,15-1,65.3,69.6,17.3,9.4,27.2,4.1,192.9,N,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,5,Colonial Reign (Nakatani) | Mandella,5-1,60.4,77.6,19.5,0.7,21.5,12.3,192.1,Y,N,2
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,3,Like a Tiger (Baze) | Greely,5-1,52.5,75.4,17.2,15.7,16.2,12.3,189.3,N,N,-2
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,6,Saint Chrisjon (Court) | Capestro,15-1,54.0,66.6,23.7,0.7,25.1,4.1,174.3,Y,N,4
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,4,Alwayswantmore (Espinoza) | Hendricks,15-1,59.1,62.0,13.4,8.3,22.2,4.1,169.1,Y,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,8,Fountain Grove (Gomez) | Capestro,15-1,58.1,44.1,23.1,0.7,26.6,4.1,156.7,Y,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,7,Fra Diavolo (ARG) (Solis) | Mandella,8-1,0.6,48.0,32.2,0.7,24.9,7.7,114.1,Y,N,-4
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,4,Shoot for Gold (Gomez) | Duncan,3-1,73.5,76.3,105.8,15.4,16.6,21.9,309.6,Y,N,5
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,3,Taps for Liberty (Valdivia) | McAnally,4-1,73.5,78.8,18.5,0.0,12.8,16.4,200.0,Y,N,1
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,2,Proud Suzett (Martinez) | Gonzalez,6-1,81.0,44.3,36.4,9.6,8.9,10.9,191.1,N,N,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,7,Lass Lil' Sunrise (John) | Dutton,15-1,43.2,54.2,59.2,3.7,12.2,4.4,176.9,Y,N,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,10,Pavona (Steiner) | Kitchingman,9-2,58.2,50.4,13.7,8.8,16.2,14.6,161.9,Y,Y,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,5,Glory to the Top (Enriquez) | Dollase,12-1,61.7,49.2,16.2,11.1,15.7,5.5,159.4,N,N,-2
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,9,Bella Luchia (Gutierrez) | Aleman,15-1,64.1,47.0,15.1,9.9,7.0,4.4,147.5,Y,N,-2
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,6,She's a Bold Lady (Court) | Wilmot,20-1,63.1,35.6,13.7,8.2,7.4,3.3,131.3,N,N,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,1,Summer Jersey (Baze) | Yakteen,5-1,0.8,0.9,7.3,0.0,10.1,13.1,32.3,Y,N,na
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,8,Veela (Smith) | Vienna,12-1,0.8,0.9,7.3,0.0,13.0,5.5,27.5,Y,Y,na
Input looks like this:
=====================INPUT===============================
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,
5,Mysterious Cat (Piermarini) | Nunez,4-1,107.6,120.8,35.8,9.7,10.6,15.1,299.7,N,Y,0
3,Jammin J J (Valenzuela) | Glatt,2-1,106.3,65.8,30.3,20.3,44.1,30.3,297.1,N,N,3
4,Good Cop Bad Cop (Rivera) | Cardenas,4-1,109.8,88.7,24.4,9.3,22.6,15.1,269.9,Y,N,3
6,Award Winning Team (Gomez) | Carava,7-2,110.3,69.5,22.1,11.3,36.0,17.3,266.5,N,N,0
7,Devil's Money (Martinez) | Gonzalez,4-1,106.0,64.6,23.7,9.2,23.9,15.1,242.4,N,N,0
2,Proud Alvin (Jauregui) | Hernandez,15-1,89.7,31.7,11.0,6.2,22.9,4.0,165.4,Y,N,0
1,Danceascore (Castanon) | Olivarez,20-1,69.2,40.2,12.7,0.7,0.0,3.0,125.7,Y,N,1
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,
2,Ran for the Dough (Sorenson) | Gallagher,6-1,116.6,125.9,12.2,9.8,34.9,9.9,309.3,N,N,0
5,Princess Sequoia (Desormeaux) | Ellis,2-1,71.7,111.5,11.7,5.6,47.5,29.7,277.6,N,N,-4
4,Dolly Wells (ARG) (Espinoza) | De,3-1,81.1,97.4,18.6,11.9,44.4,19.8,273.2,N,N,0
1,Redmeansgo (Valenzuela) | Becerra,5-2,74.5,90.9,15.3,23.3,41.1,23.8,268.9,N,N,0
6,Brave Miss (Douglas) | Stute,12-1,65.3,110.6,7.6,7.0,38.1,5.0,233.6,N,N,-2
3,Sharpened Copy (Solis) | Headley,5-1,70.7,76.3,14.6,9.1,34.0,11.9,216.6,N,N,0
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,
4,West Coast Gee Gee (Nakatani) | Glatt,3-1,82.3,63.7,33.7,10.2,28.6,21.7,240.0,Y,N,-3
7,The Borg Queen (Valenzuela) | Dolan,4-1,60.1,76.6,46.3,6.0,33.2,16.2,238.4,N,N,-1
2,Kind Lena (Cohen) | Bernstein,6-1,74.7,71.3,32.2,7.1,23.2,10.8,219.3,Y,N,-8
1,Rozys Account (Court) | McCarthy,5-1,65.5,62.5,26.3,8.5,30.5,13.0,206.4,Y,N,4
8,Vegas Folly (Pedroza) | Carava,9-2,64.1,64.9,28.2,7.5,25.8,14.4,205.1,Y,N,-1
5,Dance of the Year (Atkinson) | Robbins,6-1,61.4,63.4,27.9,7.3,20.3,10.8,191.1,N,N,-4
3,La Chola (Espinoza) | Moreno,10-1,55.5,42.9,34.2,13.2,27.9,6.5,180.1,N,N,-3
6,Mysterious Peace (Martinez) | Dunham,10-1,56.5,36.0,37.8,6.9,10.5,6.5,154.2,N,N,-1
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,
3,Me Moe You Curly (Figueroa) | O'Neill,9-5,151.5,153.8,21.8,0.0,20.3,19.7,367.1,Y,Y,5
8,Dominated Girl (Valenzuela) | Periban,5-2,111.2,84.7,115.3,19.1,20.7,14.2,365.2,N,N,2
6,Anearlyfil (Urieta-Moran) | Stute,10-1,83.7,93.3,49.5,14.5,16.7,3.6,261.2,N,N,0
4,Suspicious Town (Berrio) | Avila,10-1,80.8,57.5,41.5,17.9,22.5,3.6,223.7,N,N,0
1,Memorly (Gomez) | Cerin,5-1,79.5,74.9,15.9,1.2,19.4,7.1,198.0,Y,Y,2
2,Tintinabulation (Court) | Shulman,5-1,84.8,57.2,18.4,14.0,13.3,7.1,194.8,N,N,0
5,Forgiving (Ochoa) | Moreno,15-1,87.4,46.1,21.8,0.0,29.9,2.4,187.6,Y,N,-9
7,Heavenly Valentine (Baze) | Glatt,15-1,1.0,1.3,9.2,0.0,17.2,2.4,31.0,Y,N,na
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,
2,Polyfirst (FR) (Douglas) | Mandella,9-5,124.3,94.2,30.6,27.0,34.8,32.7,343.6,N,N,0
4,Quatrain (Solis) | Sadler,5-2,112.7,83.4,29.1,0.9,30.8,23.5,280.4,Y,N,-3
5,Megec Blis (IRE) (Espinoza) | Cardenas,7-2,105.5,72.6,26.1,14.0,35.5,16.8,270.5,Y,N,0
3,Cousineau (Nakatani) | Dollase,8-1,105.7,94.3,19.7,10.5,27.2,7.4,264.6,Y,N,0
6,Fortunately (GB) (Valdivia) | Yakteen,6-1,115.1,63.6,21.9,12.4,20.4,9.8,243.2,Y,N,0
1,The Usual (Desormeaux) | Abrams,12-1,75.7,100.6,28.8,0.9,31.3,4.9,242.2,N,N,-4
7,Exclusive Danielle (GB (Court) | Shulman,12-1,1.2,16.4,30.4,0.9,20.0,4.9,73.8,Y,N,-3
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,
5,Beau (Court) | Hendricks,3-1,74.9,142.6,76.5,11.7,22.4,11.8,339.9,N,N,0
3,Spectacular Bay (Martinez) | DeLeon,9-2,61.0,108.9,59.5,9.7,15.1,7.9,262.1,N,N,0
6,Zeetop (Valenzuela) | Knapp,2-1,65.6,81.6,58.9,11.0,27.1,17.8,262.0,N,N,0
2,Virgo Genius (Baze) | Stute,15-1,65.6,74.5,36.0,7.0,23.6,2.4,209.0,N,N,0
8,Haven House (Smith) | Lewis,5-2,61.6,79.1,20.6,11.6,21.3,14.2,208.4,N,N,0
7,Swiss Alps (Baze) | Harrington,15-1,57.3,72.6,16.3,8.8,17.0,2.4,174.3,N,N,-2
1,He's My Bud (Cohen) | Mendoza,30-1,53.5,52.0,16.3,6.9,18.1,1.2,147.9,N,Y,-2
4,Inherent (Jauregui) | Mulhall,15-1,0.7,1.2,9.2,0.0,15.3,2.4,28.8,Y,N,na
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,
2,Drake's Victory (Valenzuela) | Canani,3-1,57.2,93.0,32.0,16.5,13.5,20.5,232.7,Y,N,0
1,Dr. Ramos (Douglas) | Cerin,2-1,72.9,32.5,34.8,13.9,22.7,30.8,207.6,N,N,-2
9,Rhythm King (Stevens) | Mandella,15-1,65.3,69.6,17.3,9.4,27.2,4.1,192.9,N,N,0
5,Colonial Reign (Nakatani) | Mandella,5-1,60.4,77.6,19.5,0.7,21.5,12.3,192.1,Y,N,2
3,Like a Tiger (Baze) | Greely,5-1,52.5,75.4,17.2,15.7,16.2,12.3,189.3,N,N,-2
6,Saint Chrisjon (Court) | Capestro,15-1,54.0,66.6,23.7,0.7,25.1,4.1,174.3,Y,N,4
4,Alwayswantmore (Espinoza) | Hendricks,15-1,59.1,62.0,13.4,8.3,22.2,4.1,169.1,Y,N,0
8,Fountain Grove (Gomez) | Capestro,15-1,58.1,44.1,23.1,0.7,26.6,4.1,156.7,Y,N,0
7,Fra Diavolo (ARG) (Solis) | Mandella,8-1,0.6,48.0,32.2,0.7,24.9,7.7,114.1,Y,N,-4
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,
4,Shoot for Gold (Gomez) | Duncan,3-1,73.5,76.3,105.8,15.4,16.6,21.9,309.6,Y,N,5
3,Taps for Liberty (Valdivia) | McAnally,4-1,73.5,78.8,18.5,0.0,12.8,16.4,200.0,Y,N,1
2,Proud Suzett (Martinez) | Gonzalez,6-1,81.0,44.3,36.4,9.6,8.9,10.9,191.1,N,N,0
7,Lass Lil' Sunrise (John) | Dutton,15-1,43.2,54.2,59.2,3.7,12.2,4.4,176.9,Y,N,0
10,Pavona (Steiner) | Kitchingman,9-2,58.2,50.4,13.7,8.8,16.2,14.6,161.9,Y,Y,0
5,Glory to the Top (Enriquez) | Dollase,12-1,61.7,49.2,16.2,11.1,15.7,5.5,159.4,N,N,-2
9,Bella Luchia (Gutierrez) | Aleman,15-1,64.1,47.0,15.1,9.9,7.0,4.4,147.5,Y,N,-2
6,She's a Bold Lady (Court) | Wilmot,20-1,63.1,35.6,13.7,8.2,7.4,3.3,131.3,N,N,0
1,Summer Jersey (Baze) | Yakteen,5-1,0.8,0.9,7.3,0.0,10.1,13.1,32.3,Y,N,na
8,Veela (Smith) | Vienna,12-1,0.8,0.9,7.3,0.0,13.0,5.5,27.5,Y,Y,na
===============OUTPUT==============================
I want the output to look like this:
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,5,Mysterious Cat (Piermarini) | Nunez,4-1,107.6,120.8,35.8,9.7,10.6,15.1,299.7,N,Y,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,3,Jammin J J (Valenzuela) | Glatt,2-1,106.3,65.8,30.3,20.3,44.1,30.3,297.1,N,N,3
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,4,Good Cop Bad Cop (Rivera) | Cardenas,4-1,109.8,88.7,24.4,9.3,22.6,15.1,269.9,Y,N,3
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,6,Award Winning Team (Gomez) | Carava,7-2,110.3,69.5,22.1,11.3,36.0,17.3,266.5,N,N,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,7,Devil's Money (Martinez) | Gonzalez,4-1,106.0,64.6,23.7,9.2,23.9,15.1,242.4,N,N,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,2,Proud Alvin (Jauregui) | Hernandez,15-1,89.7,31.7,11.0,6.2,22.9,4.0,165.4,Y,N,0
1st,6.0F (Dirt) Clm 10000 ($14000) 4UPyo,1,Danceascore (Castanon) | Olivarez,20-1,69.2,40.2,12.7,0.7,0.0,3.0,125.7,Y,N,1
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,2,Ran for the Dough (Sorenson) | Gallagher,6-1,116.6,125.9,12.2,9.8,34.9,9.9,309.3,N,N,0
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,5,Princess Sequoia (Desormeaux) | Ellis,2-1,71.7,111.5,11.7,5.6,47.5,29.7,277.6,N,N,-4
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,4,Dolly Wells (ARG) (Espinoza) | De,3-1,81.1,97.4,18.6,11.9,44.4,19.8,273.2,N,N,0
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,1,Redmeansgo (Valenzuela) | Becerra,5-2,74.5,90.9,15.3,23.3,41.1,23.8,268.9,N,N,0
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,6,Brave Miss (Douglas) | Stute,12-1,65.3,110.6,7.6,7.0,38.1,5.0,233.6,N,N,-2
2nd,8.5F (Dirt) AlwOC 52000n1x c40k ($52000) 4UPyo,3,Sharpened Copy (Solis) | Headley,5-1,70.7,76.3,14.6,9.1,34.0,11.9,216.6,N,N,0
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,4,West Coast Gee Gee (Nakatani) | Glatt,3-1,82.3,63.7,33.7,10.2,28.6,21.7,240.0,Y,N,-3
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,7,The Borg Queen (Valenzuela) | Dolan,4-1,60.1,76.6,46.3,6.0,33.2,16.2,238.4,N,N,-1
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,2,Kind Lena (Cohen) | Bernstein,6-1,74.7,71.3,32.2,7.1,23.2,10.8,219.3,Y,N,-8
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,1,Rozys Account (Court) | McCarthy,5-1,65.5,62.5,26.3,8.5,30.5,13.0,206.4,Y,N,4
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,8,Vegas Folly (Pedroza) | Carava,9-2,64.1,64.9,28.2,7.5,25.8,14.4,205.1,Y,N,-1
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,5,Dance of the Year (Atkinson) | Robbins,6-1,61.4,63.4,27.9,7.3,20.3,10.8,191.1,N,N,-4
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,3,La Chola (Espinoza) | Moreno,10-1,55.5,42.9,34.2,13.2,27.9,6.5,180.1,N,N,-3
3rd,8.0F (Dirt) Clm 20000 ($25000) 4UPyo,6,Mysterious Peace (Martinez) | Dunham,10-1,56.5,36.0,37.8,6.9,10.5,6.5,154.2,N,N,-1
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,3,Me Moe You Curly (Figueroa) | O'Neill,9-5,151.5,153.8,21.8,0.0,20.3,19.7,367.1,Y,Y,5
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,8,Dominated Girl (Valenzuela) | Periban,5-2,111.2,84.7,115.3,19.1,20.7,14.2,365.2,N,N,2
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,6,Anearlyfil (Urieta-Moran) | Stute,10-1,83.7,93.3,49.5,14.5,16.7,3.6,261.2,N,N,0
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,4,Suspicious Town (Berrio) | Avila,10-1,80.8,57.5,41.5,17.9,22.5,3.6,223.7,N,N,0
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,1,Memorly (Gomez) | Cerin,5-1,79.5,74.9,15.9,1.2,19.4,7.1,198.0,Y,Y,2
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,2,Tintinabulation (Court) | Shulman,5-1,84.8,57.2,18.4,14.0,13.3,7.1,194.8,N,N,0
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,5,Forgiving (Ochoa) | Moreno,15-1,87.4,46.1,21.8,0.0,29.9,2.4,187.6,Y,N,-9
4th,5.5F (Dirt) Md 25000 ($16000) 4UPyo,7,Heavenly Valentine (Baze) | Glatt,15-1,1.0,1.3,9.2,0.0,17.2,2.4,31.0,Y,N,na
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,2,Polyfirst (FR) (Douglas) | Mandella,9-5,124.3,94.2,30.6,27.0,34.8,32.7,343.6,N,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,4,Quatrain (Solis) | Sadler,5-2,112.7,83.4,29.1,0.9,30.8,23.5,280.4,Y,N,-3
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,5,Megec Blis (IRE) (Espinoza) | Cardenas,7-2,105.5,72.6,26.1,14.0,35.5,16.8,270.5,Y,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,3,Cousineau (Nakatani) | Dollase,8-1,105.7,94.3,19.7,10.5,27.2,7.4,264.6,Y,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,6,Fortunately (GB) (Valdivia) | Yakteen,6-1,115.1,63.6,21.9,12.4,20.4,9.8,243.2,Y,N,0
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,1,The Usual (Desormeaux) | Abrams,12-1,75.7,100.6,28.8,0.9,31.3,4.9,242.2,N,N,-4
5th,6.5F (Turf) Alw 52000n2x ($52000) 4UPyo,7,Exclusive Danielle (GB (Court) | Shulman,12-1,1.2,16.4,30.4,0.9,20.0,4.9,73.8,Y,N,-3
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,5,Beau (Court) | Hendricks,3-1,74.9,142.6,76.5,11.7,22.4,11.8,339.9,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,3,Spectacular Bay (Martinez) | DeLeon,9-2,61.0,108.9,59.5,9.7,15.1,7.9,262.1,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,6,Zeetop (Valenzuela) | Knapp,2-1,65.6,81.6,58.9,11.0,27.1,17.8,262.0,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,2,Virgo Genius (Baze) | Stute,15-1,65.6,74.5,36.0,7.0,23.6,2.4,209.0,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,8,Haven House (Smith) | Lewis,5-2,61.6,79.1,20.6,11.6,21.3,14.2,208.4,N,N,0
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,7,Swiss Alps (Baze) | Harrington,15-1,57.3,72.6,16.3,8.8,17.0,2.4,174.3,N,N,-2
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,1,He's My Bud (Cohen) | Mendoza,30-1,53.5,52.0,16.3,6.9,18.1,1.2,147.9,N,Y,-2
6th,8.5F (Dirt) Md 40000 ($23000) 3yo,4,Inherent (Jauregui) | Mulhall,15-1,0.7,1.2,9.2,0.0,15.3,2.4,28.8,Y,N,na
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,2,Drake's Victory (Valenzuela) | Canani,3-1,57.2,93.0,32.0,16.5,13.5,20.5,232.7,Y,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,1,Dr. Ramos (Douglas) | Cerin,2-1,72.9,32.5,34.8,13.9,22.7,30.8,207.6,N,N,-2
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,9,Rhythm King (Stevens) | Mandella,15-1,65.3,69.6,17.3,9.4,27.2,4.1,192.9,N,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,5,Colonial Reign (Nakatani) | Mandella,5-1,60.4,77.6,19.5,0.7,21.5,12.3,192.1,Y,N,2
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,3,Like a Tiger (Baze) | Greely,5-1,52.5,75.4,17.2,15.7,16.2,12.3,189.3,N,N,-2
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,6,Saint Chrisjon (Court) | Capestro,15-1,54.0,66.6,23.7,0.7,25.1,4.1,174.3,Y,N,4
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,4,Alwayswantmore (Espinoza) | Hendricks,15-1,59.1,62.0,13.4,8.3,22.2,4.1,169.1,Y,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,8,Fountain Grove (Gomez) | Capestro,15-1,58.1,44.1,23.1,0.7,26.6,4.1,156.7,Y,N,0
7th,8.0F (Turf) Alw 52000n1x ($52000) 4UPyo,7,Fra Diavolo (ARG) (Solis) | Mandella,8-1,0.6,48.0,32.2,0.7,24.9,7.7,114.1,Y,N,-4
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,4,Shoot for Gold (Gomez) | Duncan,3-1,73.5,76.3,105.8,15.4,16.6,21.9,309.6,Y,N,5
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,3,Taps for Liberty (Valdivia) | McAnally,4-1,73.5,78.8,18.5,0.0,12.8,16.4,200.0,Y,N,1
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,2,Proud Suzett (Martinez) | Gonzalez,6-1,81.0,44.3,36.4,9.6,8.9,10.9,191.1,N,N,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,7,Lass Lil' Sunrise (John) | Dutton,15-1,43.2,54.2,59.2,3.7,12.2,4.4,176.9,Y,N,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,10,Pavona (Steiner) | Kitchingman,9-2,58.2,50.4,13.7,8.8,16.2,14.6,161.9,Y,Y,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,5,Glory to the Top (Enriquez) | Dollase,12-1,61.7,49.2,16.2,11.1,15.7,5.5,159.4,N,N,-2
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,9,Bella Luchia (Gutierrez) | Aleman,15-1,64.1,47.0,15.1,9.9,7.0,4.4,147.5,Y,N,-2
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,6,She's a Bold Lady (Court) | Wilmot,20-1,63.1,35.6,13.7,8.2,7.4,3.3,131.3,N,N,0
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,1,Summer Jersey (Baze) | Yakteen,5-1,0.8,0.9,7.3,0.0,10.1,13.1,32.3,Y,N,na
8th,7.0F (Dirt) Md 40000 ($21000) 3yo,8,Veela (Smith) | Vienna,12-1,0.8,0.9,7.3,0.0,13.0,5.5,27.5,Y,Y,na