AnsweredAssumed Answered

Transforming EDI for mail message

Question asked by jasonarnold2721 on May 16, 2014
Latest reply on May 20, 2014 by ted.sager
Hey Everyone!
 
I am trying to send an email message for each 850 that comes in to our PO workflow system. The emailing part is working fine but I need to transform the data from this: (Which is how it comes out by default)
 
ST*850*0002~BEG*00*DS*7179697**20140512~REF*CO*20140145~REF*EU*.~TD5***SC**See Shipping Comment~N9*ZZ*A US~MSG*Pls ship the order and charge to ~N1*BT*Corporation~N3*4l Drive~N4*Fremont*CA*94538~PER*IC*Juu~N1*ST*HAOLS*ZZ*CM98~N3*AM AVENUE~N4*HAMDEN*CT*06517*US~PER*IC*plan*TE*7940 x2280~N1*SN*EAMMUNICATIONS*ZZ*552308~N3*1051BATTKWAY~N4*MASAS*VA*20109*US~PER*IC*DMANN~N1*EU*Hamools~N3*60 Punue~N4*HA*CT*06517~PER*IC*Kplan*TE*703-393-1940 x2280*EM*Aaralk.com~PO1*1*20*EA*824.45**VP*TAW4*BP*ANPW4~DTM*010*20140512~DTM*002*20140516~CTT*1*20~SE*75*0002~
 
To This: (So it is easier for people to read if necessary)
 
ST*850*0002~
BEG*00*DS*7179697**20140512~
REF*CO*20140145~
REF*EU*.~
TD5***SC**See Shipping Comment~
N9*ZZ*AN US~
MSG*Pls ship the order and charge to x~
N1*BT*Soration~
N3*4el Drive~
N4*Frnt*CA*94538~
PER*IC*Jusu~
N1*ST*HAMOLS*ZZ*CM98~
N3*AM AVENUE~
N4*HAN*CT*0617*US~
PER*IC*Kan*TE*700 x2280~
N1*SN*EARATIONS*ZZ*552308~
N3*10511 PARKWAY~
N4*MASAS*VA*29*US~
PER*IC*DAMANN~
N1*EU*Hamols~
N3*6 Punue~
N4*HAN*CT*017~
PER*IC*Kaan*TE*7040 x2280*EM*Aaom~
PO1*1*20*EA*824.45**VP*TPW4*BP*A/PW4~
DTM*010*20140512~
DTM*002*20140516~
CTT*1*20~
 
I have been experimenting with additional EDI and Flat File maps in a second branch step before the message or mail connector shape but wanted to see if there is an easier way.
 
Thanks

Outcomes