TEXT-TO-CSV FILE CONVERTER 

Formatting rules and assumptions:

1. Lines that begin with a month abbreviation, e.g., Feb, in column 1 or 2 are deleted. The assumption is that it is a page break not wanted in the CSV file.

2. Grid lines, i.e. lines that contain a series of 4 or more dashes or underscores like those used in tables are skipped.

3. Vertical bars (|) like those used in tables are removed and treated as cell breaks. The grave accent (`) is treated the same as the vertical bar.

4. Text strings are separated from numbers and put in separate cells. Thus the string “Correlation Coefficient: .37” will appear in two adjacent cells.

5. ‘?’ is used as a place holder for a cell when preceded by a blank. Thus ‘ ? ? hello’ puts ‘hello’ in the third cell.

6. A string enclosed in double quotes surrounded by blanks is treated as a single cell except that extra blanks are removed.

7. [PLOT] at the beginning of a line signals the following lines are to go into the first cell. [END] at the beginning of a line signals stop putting lines into the fist cell. To display properly in Excel, these lines should have a monospace font, like Consolas, applied.

8. An initial line indicating the source and current date is inserted in the file.