Where is ascii.tgz in the software download? - RE: Non-printable sign
I went to the IIUG software area, and all it has were links to: IDS-11.5 OAT Server Studio Sentinel Member Area Home So where can I find ascii.tgz ?? Thanks... Rob -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Jonathan Leffler Sent: Tuesday, May 27, 2008 7:54 AM To: informix-list@iiug.org Subject: Re: Non-printable sign On May 26, 2:23 am, DeMi <michal.dem...@gmail.com> wrote: > I have problem with replacing non-printable 'new line' sign (^J) to > null. Actually, I don't know if Informix provides function like > Oracle's ord() or ascii() which would be helpful. > My task is to unload rows from sql query into file with default > delimiter '|'. It is very important that each record is written in one > separate line. However, it happens that one field can contain the 'new > line' sign. In this case my row is split into two lines which is not > allowed. The interested field is varchar type. > > Does anybody solved this kind of problem and how? It strikes me that replacing the newlines with ASCII NUL '\\0' would not be a good idea; that would mark the end of the string and effectively truncate anything after the newline. You would probably be better of replacing it with a blank. For mechanics, you should look at the REPLACE function - assuming you have a sufficiently recent version of IDS. There is also an ASCII function in IDS (11.50 at least, but I believe at least some earlier versions). There doesn't seem to be an ORD() or CHR() function built in -- odd, I thought it was added at the same time as ASCII (it should have been). If you poke around the IIUG web site, you should find a package ascii.tgz containing a now redundant ASCII function and a still relevant CHR function plus the data for a table which those functions use - and a script to assemble it all. (Contents: ascii.sql, ascii.unl, asciitbl.sql, chr.sql, mkascii.sql) If you really can't find that after some searching, contact me. You'd then use CHR(10) in the REPLACE function search string. There are probably other ways of doing it too. -=JL=- _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
Konikoff, Robert W MAJ RET wrote: > I went to the IIUG software area, [...] > So where can I find ascii.tgz ?? http://www.iiug.org/software/index_MISC.html It's listed as just ASCII - but the download is ascii.tgz Repository search on ASCII lists this - not top, but close. > On Behalf Of Jonathan Leffler > [...] > If you poke around the IIUG web site, you should find a package > ascii.tgz -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-3349 ripemd256 2008-05-28 03:00:06 C3D596E9F6498794084AC7CDDB8CE7678DE25C29C18FA51D9147A0AC69D6AA9A