want to retrieve data from txt file into different fields...

[skalavati]

Purchase Order:9240 STORES INC. Page: 1
Status: ACTIVE Print Date: 04/04/2006 04:33:54 By: SAB5
Quote Id: 1020707 /\/\/\/\/\/\/\/\ IMPORT PURCHASE ORDER /\/\/\/\/\/\/\/\ Create Date: 04/03/2006
Buy Plan Id: Buy Trip Id: Revised Date: 04/03/2006 19:05:01 By: AUTOQP
Preclass Status: COMPLETE Preclass Approval Date: 03/31/2006 By: kcriner
_____________________________________________________________________________________________________________________________________________________________________________
Division: 12 Ordering Buyer: CLAUDIA I JOSEPH Credit Office: INDIA
Department: 20 Managing Buyer: CLAUDIA I JOSEPH Logistics Office: INDIA
Destination: UNITED STATES Vendor Name: bar INTERNATIONAL LTD Creation Office: SUPPLIER QUOTE APPLICATION
Host Vendor: 010351-200
VENDOR#: 30000547 BANK: 25801528 PRIMARY BENEFICIARY: 30000547 SECONDARY BENEFICIARY: BUYING AGENT1: 847 BUYING AGENT2:
....... ..... .................... ...................... .............. ..............
bar INTERNATIONAL LTD CANARA BANK bar INTERNATIONAL LTD INDIA
14 KAMARAJAPURAM EAST K.G. TOWERS 14 KAMARAJAPURAM EAST 2ND FLOOR, TOWER D
karai -002, TAMIL NADU, 37, KOVAI ROAD karai -002, TAMIL NADU, DIAMOND DISTRICT
INDIA karai 002 INDIA INDIA 150 AIRPORT ROAD
karai 002 INDIA karai 002 INDIA KODIHALLI
bgl 560 008 INDIA
_________________________________________________________________________________________________________________________________________________________________________________
Notes: General Comments
Acceptance Clause This PO will be deemed as accepted unless the supplier notifies the managing office of any requested changes within ten calendar days from
the purchase order creation date. Also, should not be held liable for any data entry errors in the PO.
Security Supplier is responsible for factory & container security until such time as the container/merchandise is delivered to the ocean terminal,
authorized yard, or consolidation point. Immediately report container seal changes to the Origin Cargo Manager.
_________________________________________________________________________________________________________________________________________________________________________________
DESTINATION VENDOR MASTER QUANTITY TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL TOTAL
SHIP DATE CARTONS (EA.) VOLUME WEIGHT NET FIRST LANDED STORE RETAIL STORE GROSS
CANCEL DATE IN CBM IN KGS. COST COST COST COST MARGIN
_________________________________________________________________________________________________________________________________________________________________________________
SUFFOLK-FLOW 06/22/2006 636 87,768 161.5440 13864.80 188,145.21 228,593.66 241,168.91 554,235.84 313,066.93USD
06/29/2006 5,704.8725(feet)
Whse Ship Date: 07/28/2006 Country of origin: INDIA Place of Possession: JAWAHARLAL NEHRU
Whse Cancel Date: 08/04/2006 Consolidator: MAERSK LOGISTICS Incoterm: FOB
Loading Port: JAWAHARLAL NEHRU Deconsolidator: Season:
Discharge Port: Broker: UPS SUPPLY CHAIN SOLUTIONS, INC. Event: HARV
Entry Port: Storage Facility: In Store Date: 08/07/2006
Transport Mode: OCEAN In Storage Date: WMT Week: 28
Warehouse Nmbr: 00000 Storage Day Count: OTB: 2006/8
PO Type: 43 Payment Ref: Sample: N
Purchase Order:9240 Payment Method: LC - At Sight Business Format:
Container Size: ' - Net Days Due:
Ship Nbr: 4











Can anybody help!!!!!!!!!!![/url][/code][/list]

 

[Norie]

What's the actual question?

 

[skalavati]

i want to retrieve data that is word format into different fields like destination, master cartons, etc.

 

[Norie]

Yes I understand that but I think to help we would need more specifics.

Exactly what do you want to retrieve?

Is the data posted 1 file/record?

 

[skalavati]

if needed i can send as a proper xl file .....i do not know how to attach in this forum.....