I have a large text file (10,000 lines) that I need import into a spreadsheet or database. It was presented to me in a formated style with page breaks and headers etc.
I have whittled it down to the following format:
0038 R&B USEN-4 PRIVATE
RVUs STD CHG 896.00 0 66 59136.00 0 727 652465.00
0053 R&B USEN 4 PRIVATE RM REQUEST
RVUs STD CHG 862.00 0 20 17240.00 0 147 127449.00
0054 USEN 4 PRIVATE DIFFERENTIAL
RVUs STD CHG 35.00 0 20 700.00 0 147 5166.00
18003 OBSERVATION FIRST HOUR USEN 4
RVUs STD CHG 322.00 0 86 27692.00 0 857 277024.00
18004 OBSERVATION EA ADDIT'L HOUR U4
RVUs STD CHG 63.00 0 1846 116298.00 0 21672 1370457.00
Ideally, the lines beginning with "RVUs" should be appended to the end of the line above them, forming one line of data instead of two. The easiest way (I think) would be to select the RVU lines, delete them, pipe them into a new text document, then import each text file seperately. I just don't know how to do it.
Any help on which editor would be best for this or how to do this would be appreciated.
This seems like it should be simple, I've just never had to do this before so I not sure where to start.