Hi Bob, This was an interesting topic to look up. That data must be coming from a company running some very old main frame. If you haven't already looked at the Wikipedia entry for EBCDIC it's both informative (this goes straight back to punch cards) and humorous. https://en.wikipedia.org/wiki/EBCDIC
If I were you I'd try this product: https://www.vedit.com/try-buy.html If it works tell the client to buy and it and task one of their folks to do the conversion and verify the data are OK for import. Apparently there is no hard and fast rule for handling all the encodings - just a general consensus. I would be careful of putting myself in the line of fire there. On Mon, Oct 7, 2019 at 5:53 AM Bob Miller via 4D_Tech <[email protected]> wrote: > Hello, > > I have a project where sales data is being sent to an FTP site and I'm > picking it up and importing into 4D. The latest dataset comes from Asia > Pacific and is stored as a double byte character set in EBCIDIC format. I > need to somehow open this and convert it back to the source character > base, which is Simplified Chinese. > > I have no idea where to start with this; any ideas would be most welcome! > > Thank you, > > -Bob Miller > Parker Hannifin Corp. > > llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll > "PLEASE NOTE: The preceding information may be confidential or privileged. > It only should be used or disseminated for the purpose of conducting > business with Parker. If you are not an intended recipient, please notify > the sender by replying to this message and then delete the information from > your system. Thank you for your cooperation. Parker Hannifin Corporation > and its subsidiaries, affiliates and associated companies ("Parker") > process personal data in accordance with Parker’s Personal Data Privacy > Policy which may be accessed from www.parker.com" > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- Kirk Brooks San Francisco, CA ======================= What can be said, can be said clearly, and what you can’t say, you should shut up about *Wittgenstein and the Computer * ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
