SQLite Forum

Set diferent Quote Character
Login
Hi Richard,

Yes im using the .import command from the CLI to read file into a table.

 .mode csv

 .separator "|"

.import Fan_extrac_ccontac_26082020.txt BS_CCONTACT_ALL

And I get the following error in some fields:


Fan_extrac_ccontac_26082020.txt:81862: unescaped " character
Fan_extrac_ccontac_26082020.txt:16780: unescaped " character


219165|3||||||||||||17009||X|140349529|3794041321||
88545067|4|FAVIAN AGUSTIN|MARTIN|S/N -- (PREG POR FLIA DE "TAPIOLA")|S/N||3705|Catamarca|BARRIO LAS PARCELAS||X||9424||||||
22314319|1|JUAN CARLOS|FORNAS|AVDA GRAL LAS HERAS|3395|9   "B"|C1425ASK|CAPITAL FEDERAL|(RUGGIERI Y PACHECO DE MELO)|48025563||X|3137|||||Sr.|

I need to set something Like: quote = none, 
The process detect " as a text qualifier, and i don't want that.


Sorry, my english is not good.
Thank you very much
Regards