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

Dear Excel Experts,
Please help me to resolve the mentioned query.
Thanks in a advance.

Ravindrak

Superb Sir,
You have done, what i have expected, only minor bug is...
It is taking some time for opening and execution as it contains formula maximum based rows i.e. 6000 (i have extended from 2345 to 6000) .
Can it be modified for fast execution?
Ravindrak

Can it be done through macro, becasue macro will more faster than formulae

This is just request Sirs. please check if possible.

Thanks in a advance.

Ravindrak

Dear Excel Experts,

Can it be done through macro, becasue after deleteing old text and adding new text everytime, it hangs the system.

Thanks in a advance.

Ravindrak

Dear Excel Experts,

Please help me to resolve the problem.

Thanks in a advance.

Ravindrak

Dear Excel Experts,

Kindly help me to resolve the problem.

Thanks in advance.

Ravindrak

Can anyone please help me to resolve my query.
Thanks in advance.
Ravindrak

Dear Sir,
I am unable to open attached file.
Also tried to add your given code in excel file but showing error at belwo line
"sn = .Range("A10", .Range("A" & Rows.Count).End(xlUp))"

Thanks in advance.
Ravindrak

Dear Sir,

Executing as expected, excluding small error....

Some of DGUN are appearing with single quotations mark (‘)
Appearing Desired
3349' 3349
3082' 3082
3272' 3272
3352' 3352

Please resolve the same.
Thanks in advance.
Ravindrak

Thanks a lot Sir,
It's running perftectly, you are really charm !!

I tried to changing name from Blad1 to Ravi; changed the same in code as well as worksheet/tab name, but after changing it is not running, can you do something for the same

Ravindrak

Yesterday, i marked this post as SOLVED but still you have resolved small issue.
Thanks a lot sir for your great help, hats off to you Boss.
Ravindrak

It has come to our attention you have violated Rule 8 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)

All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.