Creation of desired data (Output) from EDI file (Input)

Dear Excel Experts,

As a new practice, we have prepare data (OUTPUT) from avaibale (INPUT)

Into INPUT worksheet 1st 9 rows are header part
from 10th row container data is there

Requirement / defination..
POSITION After text LOC+147+0, 3 characters
For Example : 131214 or 111116 etc.

WT require text in between +WT++KGM: and '
For Example : 16400 or 24700 etc

WT (VGM) require text in between +VGM++KGM: and '
For Example : 16400 or 24700 etc

POD After text LOC+9+ , 5 characters
For Example : CNTAO or CNSHA etc.

POL After text LOC+11+ , 5 characters
For Example : INMUN or INHZA etc.


Contaienr NO After text EQD+CN+ , 11 characters
For Example : AXIU2018854 or BMOU2709770 etc.


Size After text EQD+CN+11characters+ , 4 characters
For Example : 2200 or 4500 etc.


Rfr If contain TMP+2+ text, require text in between TMP+2+ and ..: & a character after :
For Example : -18C or +21 etc.

Haz If contain DGS+IMD+ text, require text in between DGS+IMD+ and ..+
For Example : 4.1 or 9 etc.

UN If contain DGS+IMD+ text, require 4 character after text DGS+IMD+ ..+
For Example : 2670 or 2211 etc.
File attached for detailes (i have done manually for few container's details not all)
Thanks in a davance
RavindraK