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

On Mar 10, 2:01 pm, "Ramon F Herrera" <r..._at_conexus.net> wrote:
> 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

It seems that the command is:

FIELDS TERMINATED BY X'1F' -Ramon Received on Sat Mar 10 2007 - 14:49:03 CST