I have several hundred lines of data. Each observation occupies two lines; however, in a number of places (not all) a blank line exists between observations. For example, between the first data element, Max Scherzer, and the second one, Justin Verlander, is a blank line. (A sample is below.)
The first two rows contain the column names. How can I remove all the blank lines? After doing that, I want to be able to paste the data back into a spreadsheet for further manipulation. Rk Name Player Matching W L W-Lpct ERA GS CG SHO SV IP H R ER HR BB SO WHIP SB CS WPA Tm 1 Max Scherzer\scherma01 Max Scherzer 84 56 8 0.875 1.56 84 8 4 0 584.1 294 107 101 53 89 787 0.66 16 5 21.1 WSN 2 Justin Verlander\verlaju01 Justin Verlander 80 49 11 0.817 1.72 80 5 3 0 554.0 269 114 106 59 88 693 0.64 9 7 18.9 DETHOU 3 Zack Greinke\greinza01 Zack Greinke 79 51 6 0.895 1.63 79 1 1 0 529.0 306 98 96 37 68 524 0.71 11 11 17.5 LADARIHOU 4 Clayton Kershaw\kershcl01 Clayton Kershaw 75 48 7 0.873 1.38 75 6 5 0 509.1 254 83 78 32 56 605 0.61 5 8 17.4 LAD -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/edced16d-6e34-498f-9899-b3a39651546cn%40googlegroups.com.
