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

Ben 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
>
> teetshd_at_ucbeh.san.uc.edu (greg teets) wrote:
>
> : On Wed, 09 Jul 1997 01:11:39 GMT, ben_at_paladin.ab.ca (Ben) wrote:
> : Why do you want to have three delimiters and why will that make it
> : foolproof? Why would a user be determining what and how many
> : characters are the delimiter.
> :
> : I can probably help you with what you're trying to do if I understand
> : it a little more.
> :
> : Thanks
> :
> : Greg Teets
> : Cincinnati, Ohio
> <snip>
Received on Thu Jul 10 1997 - 00:00:00 CDT