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 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 for quotes and preceed them with the > >> necessary escape character. > >> > >> Not being a proper database dump it's not a simple matter of flicking a > >> switch to get it to include the escape character. The way the extracts > >> are written would require a few dozen lines of code to each extract, and > >> theres about 40ish extracts. > >> > >> Plus I don't maintain that side of our code, and those that do can be a > >> bit lazy and I'd likely be waiting months to get it done - if they even > >> decide to do it. > > Pipe it through sed and replace the Carets with TABS? > > sed 's/^/\t/g' c:/temp/autodrs_deal_lines.txt > > > c:/temp/autodrs_deal_lines.tab > > > > Then use copy like so: > > \copy table from 'c:/temp/autodrs_deal_lines.tab' delimiter E'\t' null '' > > > > > > Cheers, > > Andrej > > > > > > The data contains tabs... don't ask why... I don't have a clue :P > > I'll do something along the lines of sed... but not with sed, I'll use > the command line interpreter on the OpenVMS systems where the extracts > run. I just thought there might have been a quicker way to switch it off > in the copy command, i.e. specifying "quote none" as one of the > parameters to the command. I guess not... > > Thanks for the pointers. > > P. > Phillip Smith IT Coordinator Weatherbeeta P/L 8 Moncrief Rd Nunawading, Vic, 3131 AUSTRALIA P. +613 9845 0600 F. +613 9845 0655 E. [EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
