I have a text file to import where the fields are separated by carets (^) and the text fields are surrounded by tildes (~). I figured out how to use the custom delimiter but how do I specify tildes as the quoting character? Is this even possible?
I think the only place where you can specify the quoting style is in the format specifier, where you can specify 'msq' (modern style quoting) or 'no quotes'. I think standard quoting using single or double quotes is default.
So have you tried importing your file with one of these settings and then REPLACE or PURGECHAR the tildes in your text fields?