how to import this file where header (first 4 lines) stay untouchedbut the rest is imported as CSV

[news]

PO: 30134 Received Purchase Order 02/13/08
Page: 1
created: 02/13/08 2:26p
(F16)
Sup#: 680 TOP GUN PRODUCTS

Line Part Number Ext Order Description Cost Ave. Cost
Each Core cost Ext Order Extd. Amt.
---- ---------------- --------- ---------------- ----------
---------- ---------- --------- -----------
TG 1103000800 2 06-08 DODGE 1500 242.820
242.820 .00 2 485.64
TG 2105000300 1 HEADACHE RACK D 274.860
274.860 .00 1 274.86
TG 2201010700 1 TOP GUN ACCESS 550.720
550.720 .00 1 550.72
TG 2206020700 3 TOP GUN ACCESS 258.840
258.840 .00 3 776.52
TG 2301019900 1 F/BUMPER REPLACE 550.720
550.720 .00 1 550.72

------- -----------

8 2,638.46 TOTAL




hello,
we use a linux system running progress database at our office.

We get output of reports to a text file like the one you see above.
When I import this as CSV, the bottom part (the area after the first 4
lines) is imported to it's own column and works perfectly as CSV.

however, the header files get all messed up. The header is up to the
line where the TOP GUN PRODUCTS is located.

Is there a way to get the header without columns (just one cell) and the
rest as a csv with it's own columns?

Thanks,

Oskar

 

[Roger Govier]

Hi
I am assuming it is not a CSV file to begin with.
Open file in Excel. All appears in column A.
Select A5 downward to end of List>Data>Text to Columns>Delimited>Space