"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). > You'll need to know the ascii value of the errant character. Use the hex editor available in the tools folder or PSPad has the ability. Then again if you know exactly where it is, asc(substr()) will help. -- Tracy Pearson PowerChurch Software Sent from my Android phone with K-9 Mail. _______________________________________________ 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/[email protected] ** 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.
