How big is the file? Could you possibly use FILETOSTR(), CHRTRAN(), and STRTOFILE() to replace the "bad" character?
Fred On Thu, Dec 1, 2011 at 11:02 AM, Jarvis, Matthew <[email protected]> wrote: > I gots me a problem..... > > > > I am trying to import a fixed field length text file that comes down > from our mainframe. Normally I can just FTP the thing off the server, > parse it to my liking and I'm off and running.... > > > > Well, once in a while this file has some oddball control char embedded > in each line that breaks everything when I try and read the file. Don't > ask me how it gets in there - I took me 4 months to trap the error and > save the file so I can examine it... the (literally) black box mainframe > giveth the file, the mainframe taketh the working version.... > > > > SO, my problem is this: I can't seem to be able to come up with any way > to do a global REPLACE on the file with a char that would work (or > remove it altogether). > > > > I *think* it is a Ctrl-V character because when I paste the little > square little char onto the DOS command line that's how it appears i.e. > ^V. > > > > It almost acts as some end of file marker but that doesn't seem to be > what ^v (i.e. SYN code) is in the IBM world... but that's out of my > realm so talking out my a$$ here... > > > > I've tried doing this in MS Access code, VB Script, DOS batch file - > nadda works. > > > > Thanks, > > > > Matthew Jarvis || Business Systems Analyst > IT Department > McKenzie-Willamette Medical Center > 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: > 541-744-6145 > > > > > > -------------------------------------------------------------------------- > Disclaimer: This electronic message may contain information that is > Proprietary, Confidential, or legally privileged or protected. It > is intended only for the use of the individual(s) and entity named > in the message. If you are not an intended recipient of this > message, please notify the sender immediately and delete the > material from your computer. Do not deliver, distribute or copy > this message and do not disclose its contents or take any action in > reliance on the information it contains. > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBkso=2FW_u=j0yado9dghl74dql_8s39hrvqnt5vmezw...@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.
