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

skalavati

Board Regular
Joined
Apr 16, 2002
Messages
57
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]
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,286
Office Version
  1. 365
Platform
  1. Windows
What's the actual question?
 

skalavati

Board Regular
Joined
Apr 16, 2002
Messages
57
i want to retrieve data that is word format into different fields like destination, master cartons, etc.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,286
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Apr 16, 2002
Messages
57
if needed i can send as a proper xl file .....i do not know how to attach in this forum.....
 

Watch MrExcel Video

Forum statistics

Threads
1,130,170
Messages
5,640,577
Members
417,151
Latest member
ChickenTenderer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top