Re: How do I use a field delimiter of more than 1 char in the data file?

I appreciate your input Leo, but I could have easily done string substitution obviously (perl is my language of choice) in about 2 seconds. But, I am wondering if there is a way/option to set in order for the control file and sqlload to recognize a delimiter that is more than one character or is this simply impossible? It would just be nice to know how (just to make my sporatic users' data bullet-proof). Thanks!
- Ben

Leo Put <lp2014_at_vum.be> wrote:

: You could run your file through sed and convert the 3-character
: delimeter to a 1 character delimiter (eg. |).
: Then you should be able to use sqlload.
:
: sed -e 's/:::/|/g' <fromfile >tofile
:
: Leo Put
: Vlaamse UitgeversMaatschappij Belgium
: lp2014_at_vum.be
:
: >
: > I would like three delimiter characters because the data file I am
: > using is a catalog generated by users' input through a cgi program.
: > Thus if I choose a single character delimiter to load in the control,
: > whether it is ";" or ":" or "," or "[" or whatever, it is possible
: > that a user may have put in that character into a field in the data
: > file, which would screw up the automated loading. Thus if I make a
: > three character delimiter, it is much less likely that a user will
: > happen to put in a sequence of ":::" in a data field.
: >
: > - Ben

<snip> Received on Thu Jul 10 1997 - 00:00:00 CDT