On Thu, Nov 7, 2013 at 10:50 AM, Kevin Cully <[email protected]>wrote:
> I used to import an EDI file that was fixed width into VFoxpro. If I > remember correctly, the first 2 characters indicated the field type. We > would import that into a temp table. Let's call it tempTable1 and the > structure was: > CREATE TABLE tempTable1 (cFieldType C(2), cField1 C(200), cField2 C(200), > cField3 C(200), etc.) > > We would append it into these tables, and then split them out by type > after that point. Using SQL it was incredibly fast. I wonder if MySQL > could import it as: > CREATE TABLE tempTable1 (cFieldType Character(2), cField1 TEXT) > > -------- > > That is scary. In one envelope from a specific trading partner I get all kinds of documents, 850,860,855, 856 and that trusty 997. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYJU83=59xMKp3=ckac7y_84pfqt+6_xpu6twpj0bvg...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
