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


N

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
 
Ad

Advertisements

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top