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

Specify any character using a hex ASCII value using the \xFF notation (where FF is a HEX value). Oracle SQL Loader supports any delimiters using the X'hex_string'.

More details could be found here in Appendix C: http://www.wisdomforce.com/doc/FastReaderUserGuide.pdf "Appendix C: Supported nonprintable delimiters for the Row and Column delimiters"

You can also use multi-characte value, like '!@#$%^'

On Mar 10, 1:01 pm, "Ramon F Herrera" <r..._at_conexus.net> wrote:
> All my *.dat files are created programmatically and therefore I can
> insert anyASCIIcharacter as a field separator. I have used
> characters such as ':' or '|' to mark the border between the fields,
> but needless to say, thedatamay contain those characters.
>
> What I would like to do is to use some rare (but visible) highASCII
> 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 Wed Mar 14 2007 - 13:48:44 CDT