[BUG] the program deletes the quotation mark

[Nispodzianka]

first of all your program is great, thanks for your work

Description

I use a program that converts DBC to CSV - when creating CSV, values ​​in string columns are enclosed in quotation marks (the " character). The program does not display the quotation mark, which does not bother me, but saving it causes the character to be deleted, which can be a problem because when working with large CSV files, I can only use one program that is unable to convert CSV to DBC if the quotation marks in the string columns are deleted.

Here is a fragment of the CSV I'm working on:
int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,float,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,float,float,float,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,float,float,float,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,float,float,float,int,int,int,int,int,int,int,int,int,int,int,int,int,int,string,string,string,string,string,string,string,string,string,int,int,int,int,int,int,int,int,string,int,string,string,int,int,string,string,string,int,int,int,int,int,int,int,int,string,int,string,string,int,int,string,string,string,int,int,int,int,int,int,int,int,string,string,string,string,string,string,string,string,string,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,int,float,float,float,int,int,int,int,int,int,int,int,int,int,float,float,float,int,int 1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7,0,0,7,0,0,0,101,0,0,0,0,0,0,10,0,0,0,1,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,5,0,0,6,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,1,0,0,9,0,0,0,0,0,0,0,0,0,0,0,1.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,1,0,50,"Word of Recall (OLD)","Word of Recall (OLD)","Mot de rappel (OLD)","Word of Recall (OLD)","Word of Recall (OLD)","Word of Recall (OLD)","Palabra de regreso (OLD)","Palabra de regreso (OLD)","Слово Возвращения (OLD)",0,0,0,0,0,0,0,16712190,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,,,,,,,,,,0,0,0,0,0,0,0,16712188,0,0,0,0,0,0,0,0,0,1,1,0,1.000000,1.000000,1.000000,0,0,0,0,0,0,8,0,0,0,1.000000,0.000000,0.000000,0,0 3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,0,0,0,0,0,0,101,0,0,0,0,0,0,10,0,0,0,1,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,5,0,0,6,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,20,0,0,9,0,0,10,0,0,0,0,0,0,0,0,1.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,1,0,50,"Word of Mass Recall (OLD)","Word of Mass Recall (OLD)","Mot de rappel (groupe) (OLD)","Word of Mass Recall (OLD)","Word of Mass Recall (OLD)","Word of Mass Recall (OLD)","Palabra de regreso masivo (OLD)","Palabra de regreso masivo (OLD)","Слово общего возвращения",0,0,0,0,0,0,0,16712190,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,,,,,,,,,,0,0,0,0,0,0,0,16712188,0,0,0,0,0,0,0,0,0,1,1,0,1.000000,1.000000,1.000000,0,0,0,0,0,0,8,0,0,0,0.000000,0.000000,0.000000,0,0 4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,101,0,0,0,0,0,0,10,0,0,0,1,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,5,0,0,6,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,1,0,50,"Word of Recall Other","Word of Recall Other","Mot de rappel (autre)","Wort des Rückrufs Anderer","召回他人之语","召回他人之語","Palabra de regreso de otro","Palabra de regreso de otro","Слово Возвращения другое",0,0,0,0,0,0,0,16712190,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,,,,,,,,,,0,0,0,0,0,0,0,16712188,0,0,0,0,0,0,0,0,0,1,1,0,1.000000,1.000000,1.000000,0,0,0,0,0,0,1,0,0,0,1.000000,0.000000,0.000000,0,0 5,0,0,0,150994944,131072,67108868,268435456,0,8,4096,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,101,0,0,0,0,0,0,0,0,0,0,13,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,0,1,0,0,6,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0,0,0,0,0,0,0,0,0,0,0,1611,0,50,"Death Touch","죽음의 손길","Toucher mortel","Todesberührung","死亡之触","死亡之觸","Toque mortífero","Toque mortífero","Касание смерти",0,0,0,0,0,0,0,16712190,,0,,,0,0,,,,0,0,0,0,0,0,0,16712188,"Instantly Kills the target. I hope you feel good about yourself now.....",0,"Tue instantanément la cible. J’espère que vous vous sentez bien dans votre peau maintenant...","Tötet das Ziel sofort. Ich hoffe, Ihr seid jetzt stolz auf Euch...",0,0,"Mata al objetivo instantáneamente. Supongo que eso te hará feliz...","Mata al objetivo instantáneamente. Supongo que eso te hará feliz...","Мгновенное уничтожение цели. Я надеюсь, вы не прониклись к себе отвращением...",0,0,0,0,0,0,0,16712190,,"대상을 즉사시킵니다. 에잇 치터 같으니!",,,"立即轰杀目标，很强罢……","立即殺死目標。希望你現在對自己感到滿意……",,,,0,0,0,0,0,0,0,16712188,0,0,0,0,0,0,0,0,0,0,0,0,1.000000,1.000000,1.000000,0,0,0,0,0,0,2,0,0,0,0.000000,0.000000,0.000000,0,0

Expected Behavior

I would like the program to detect the used quotation marks and not delete them

Environment

Version: 3.16.0
Tauri: 2.10.2
Webview: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36 Edg/145.0.0.0
OS: windows 10.0.26200 x86_64

[kohii]

Thank you for the report and the kind words!

I'll look into how to best handle this. Please give me some time.

[Nispodzianka]

Your SmoothCSV program has a nice option we can use in such cases !
in "CSV File Format" under "Quote mode" we have "+ Add override" and there we indicate the columns where we use quotes, in this case:
Columns: 137, 138, 139, 140, 141, 142, 143, 144, 145, 154, 156, 157, 160, 161, 162, 171, 173, 174, 177, 178, 179, 188, 189, 190, 191, 192, 193, 194, 195, 196
Rows: Body
Quote: Always

However, I hope you will find a way to ensure that even if we don't set what I described, the program will not remove the quotes when the values ​​are enclosed in quotation marks.

[kohii]

Thanks for sharing the workaround! I'm glad the quote override feature helps for now.

I do plan to improve this so that existing quotes are preserved automatically without manual configuration.

[kohii]

Fixed in https://github.com/kohii/smoothcsv3/releases/tag/v3.18.0! SmoothCSV now automatically detects irregular cell-level quoting and switches to Manual mode, so existing quotes are preserved without any manual configuration.