Hi,
I think I had the exact same problem as you do a while back and I
solved it by removing the header row and the "CSV HEADER" clause of the
statement. For the large files I had, it was easier (for me) to remove
the header row than it was to escape out all the quotes (or regen the
file):
C
Phillip Smith wrote:
Maybe use char 254 or 253 or something similar... Anything that isn't
going to be found in the file.
Have you tried using a string as a delimiter? QUOTE
'THIS.STRING.ISNT.IN.THE.TEXT.FILE'
~p
I changed it to QUOTE '\f' to set the quote character to form-feed which
is
On Tue, Mar 20, 2007 at 11:25:38AM +0900, Paul Lambert wrote:
> I note an option in the COPY command to specify the quote character,
> defaulting to double quote. The problem being a single quote will also
> be used in the data, as will other characters. Is there any way to get a
> copy to have
Maybe use char 254 or 253 or something similar... Anything that isn't
going to be found in the file.
Have you tried using a string as a delimiter? QUOTE
'THIS.STRING.ISNT.IN.THE.TEXT.FILE'
~p
On Tue, 2007-03-20 at 11:59 +0900, Paul Lambert wrote:
> Andrej Ricnik-Bay wrote:
> > On 3/20/07, Paul
Andrej Ricnik-Bay wrote:
On 3/20/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
The source file comes from extracts on our main application which sits
inside an in-house pretending-to-be-a-dbms file system. The content of
these extracts would be difficult to change - the extract program would
need
On 3/20/07, Paul Lambert <[EMAIL PROTECTED]> wrote:
The source file comes from extracts on our main application which sits
inside an in-house pretending-to-be-a-dbms file system. The content of
these extracts would be difficult to change - the extract program would
need to parse the data looking
Phillip Smith wrote:
Can you not export the source file with escape characters? ie,
^17\" Alloy Wheels^
~p
The source file comes from extracts on our main application which sits
inside an in-house pretending-to-be-a-dbms file system. The content of
these extracts would be difficult to chan
Can you not export the source file with escape characters? ie,
^17\" Alloy Wheels^
~p
On Tue, 2007-03-20 at 11:25 +0900, Paul Lambert wrote:
> I have a procedure in place that copies data from a caret delimited text
> file into a table storing some information.
>
> One of the fields in the t
I have a procedure in place that copies data from a caret delimited text
file into a table storing some information.
One of the fields in the table contains an item description which may
contain item dimensions such as - 17" alloy wheels
The problem I am getting when I do my load is I believe