AnsweredAssumed Answered

Remove duplicate segments in EDI

Question asked by venkatesh.rupanagudi080702 on Aug 10, 2017
Latest reply on Aug 14, 2017 by malleswara_rao_banis704369

Hi,

 

I have below EDI document. I need to remove duplicate N3 segment, which is causing looping issues to XML destination file. Any ideas please ?

 

ST*856*944930522~
BSN*00*00669341*20170808*102003*0001~
HL*1**S~TD1*CTN25*1****G*8.670*LB*0.688*CF~
TD5*B*91*UPSV*M*GND~
REF*CN*1ZA4800RA867134872~
REF*BM*00669341~
DTM*011*20170808*1219*LT~
FOB*TP~
N1*ST*RICHARD MORRIS*92*WE80089864~
N3*125 SOUTH NORWINDEN DRIVE*1975~
N3*RICHMORRIS25@HOTMAIL.COM*RICHMORRIS25@HOTMAIL.COM~
N4*SPRINGFIELD*PA*19064*US~
N1*SF*EXPEDITORS*91*MEM~
N3*6005 FREEPORT AVE STE 102~
N4*MEMPHIS*TN*38141*US~
HL*2*1*O~TD1*CTN25*1****G*8.670*LB*0.688*
CF~REF*VN*0080089864~
REF*ZZ*A4800R*UDF1~
REF*ZZ*EXW||USD|*UDF3~
DTM*938*20170808~
DTM*373*20170808~
DTM*374*20170808~
N1*SO*JOSE MEZA*92*0005001030~
N3*2030 DORTMUND DR~
N3*APT #821~N4*COLORADO SPRINGS*CO*80918*US~
HL*3*2*T~MAN*W*MEM0000000965101~HL*4*3*P~
PO4*1*****8.670*LB*0.688*CF~
MAN*GM*MEM0000000965101**CP*1ZA4800RA867134872~
HL*5*4*I~LIN**VN*DTHW1620H~SN1**1*EA**1*EA~
REF*LI*000010~REF*CG*WTCUS070941~
REF*ZZ*WACOM MOBILESTUDIO PRO 16-I7,*UDF1~
REF*ZZ*8471.41.0150|CN|2999.95|USD|*UDF2~
REF*ZZ*|X*UDF4~
REF*ZZ*|X|*UDF5~
REF*SE*7DH0054000489*1~
CTT*5~SE*45*944930522~

Outcomes