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?
