Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
LonnieM
Starting Member
15 Posts |
Posted - 2009-09-30 : 17:13:49
|
Hello all,I have to figure out a way to analyze the EDI (electronic data interchange) files concerning ASN (advance ship notices) from our vendors. I'm not really sure where to start. I can identify the lines I need by the first series of letters in each line. Here is a sample:ISA~00~ ~00~ ~01~929222446 ~01~042653634G ~090923~1407~U~00401~000006502~0~P}GS~SH~929222446~042653634~20090923~1407~6502~X~004010}ST~856~65020001}BSN~00~CS-0171895~20090923~14045500}DTM~011~20090923}HL~1~~S}TD1~CNT~1~~~~G~100~LB}TD5~~2~PKUP~L~PICK UP}TD3~TL~~010458}REF~VR~131456}N1~SF~XXXXXXXX XXXXXX~92~131456}N3~2000 SOUTH MAIN BLVD.}N4~XXXXXXXX~XX~XXXX}HL~2~1~I}LIN~0001~BP~0601759~VP~77417}SN1~~72~EA}PRF~110051897}PID~F~~~~AC20 BLU XXXXXXX .8M PLN-PLN 24}CTT~2}I have tried desparately to import this into some type of understandable structure with the Import Wizard to no avail. Sorry to pose such a general question but I'm just stuck.Thank you, Lonnie |
|
|
|
|