jberry123
Active Member
Has anyone used a table conversion to convert a EDI file. I am looking at
updating the 832/Pricing file through a table conversion. The format the I
recieve it in is as follows:
N1*BY**91*545045~LIN**VN*1134931*UI*30013111410*ND*00013111410~PID*X*RX***CYKLOKAPR
AMP 100MG/ML 10ML~PO4*1*10*PK~CTP**RES*279~CTP**INV*219.74
Which looks like this when wrapped.
N1*BY**91*545045
LIN**VN*1134931*UI*30013111410*ND*00013111410
PID*X*RX***CYKLOKAPR AMP 100MG/ML 10ML 10
PO4*1*10*PK
CTP**RES*279
CTP**INV*219.74
Is there a way you can do a table conversion over un-wrapped (Example 1) .
I know the '*' seperates the fields, but how do I show that the '~' is the
segment ending field?
If anyone has a better way of doing this I would like to hear. Our company
doesn't have the money at this time to purchase EDI software, so any
information would be great.
We are trying to automate this process as much as possible.
Thanks,
jb
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
updating the 832/Pricing file through a table conversion. The format the I
recieve it in is as follows:
N1*BY**91*545045~LIN**VN*1134931*UI*30013111410*ND*00013111410~PID*X*RX***CYKLOKAPR
AMP 100MG/ML 10ML~PO4*1*10*PK~CTP**RES*279~CTP**INV*219.74
Which looks like this when wrapped.
N1*BY**91*545045
LIN**VN*1134931*UI*30013111410*ND*00013111410
PID*X*RX***CYKLOKAPR AMP 100MG/ML 10ML 10
PO4*1*10*PK
CTP**RES*279
CTP**INV*219.74
Is there a way you can do a table conversion over un-wrapped (Example 1) .
I know the '*' seperates the fields, but how do I show that the '~' is the
segment ending field?
If anyone has a better way of doing this I would like to hear. Our company
doesn't have the money at this time to purchase EDI software, so any
information would be great.
We are trying to automate this process as much as possible.
Thanks,
jb
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.