Charles Load the file as csv. Change all the pipe char to a comma or reset the comma to pipe. I load some really large files that way. I just change the pipe to a comma.
Buddy -----Original Message----- From: Charles Parks <[EMAIL PROTECTED]> To: RBG7-L Mailing List <[EMAIL PROTECTED]> Sent: Wed Jun 30 12:06:33 2004 Subject: [RBG7-L] - Loading a file What is the best way to load a file that has fields delimited with a pipe (|) and no quotes and fields of text that may include a space character. Will I have to update the file so quotes are around text and the delimiters are changed to commas or is there a way to load the without manipulating the file?
