i want to get sub-string value from a text file

Mar 8 2018 2:54 AM

This is my Input text file format

BILL OF LADING FOR COMBINED TRANSPORT AND PORT TO PORT SHIPMENT

Sheet 1 of 3

SHIPPER/EXPORTER (2) DOCUMENT NO (5)

EXXON MOBIL CORPORATION NAM2998573 NAM2998573

22777 SPRINGWOODS VILLAGE PARKWAY EXPORT REFERENCES (6)

SPRING, TX 77389-1425 USA 5004753 / 6004754

4451690406

CONSIGNEE (3) FORWARDING AGENT - REFERENCES (7)

MANULI DA AMAZONIA E LOGISTICS INC (931839)

INDUSTRIA DE EMBALAGENS LTDA AV. 3050 POST OAK BLVD, STE 444 CHB:

BURITI 3670 BAIRRO DISTRITO HOUSTON, TX 77056 FMC: 025823

INDUSTRIAL 69075-000 MANAUS, AM TEL. NO. 346-802-4008

BRASIL

CNPJ/CPF: 14269557000137

NOTIFY (4) POINT AND COUNTRY OF ORIGIN (8)

MANULI DA AMAZONIA

INDUSTRIA DE EMBALAGENS LTDA AV. UNITED STATES

BURITI 3670 BAIRRO DISTRITO DOMESTIC ROUTING/EXPORT INSTRUCTIONS (9)

INDUSTRIAL 69075-000 MANAUS, AM NO SED REQUIRED - X20180206869589

BRASIL CNPJ: 14.269.557/0001-37

PIER/TERMINAL (10) COMBINED TRANSPORT*

PRECARRIAGE FROM (10A)

BAYPORT CONTAINER TERMINAL -

VESSEL (11) PORT OF LOADING (12)

TRF PESCARA

303GBS HOUSTON

My output file comes on this format . when i read First Header Name Shipper/Exporter

SHIPPER/EXPORTER (2)

EXXON MOBIL CORPORATION

22777 SPRINGWOODS VILLAGE PARKWAY

SPRING, TX 77389-1425 USA

Kindly help on this

Answers (2)