Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Need to use a rare field separator in *.dat files

Need to use a rare field separator in *.dat files

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 10 Mar 2007 12:01:38 -0800
Message-ID: <1173556898.478483.140230@s48g2000cws.googlegroups.com>

All my *.dat files are created programmatically and therefore I can insert any ASCII character as a field separator. I have used characters such as ':' or '|' to mark the border between the fields, but needless to say, the data may contain those characters.

What I would like to do is to use some rare (but visible) high ASCII value which will be essentially impossible to be present in the raw datafiles.

Is that the right approach (in some cases I cannot switch to fixed length records)?

How do I define such character in the *.ctl files?

This is what I have now:

  FIELDS TERMINATED BY "|" TIA, -Ramon F Herrera Received on Sat Mar 10 2007 - 14:01:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US