The most common use is to have the comma “,” as separator.
A value that contains commas can be enclused by double quotes;
A value that contains double quotes will be double quoted and have the embedded double quotes doubled or escaped e.g.:
This is normal,"This is a value, that has comma's (,)",this has a ""quoted"" word,this is also a \"quoted\" word
or
"This is normal","This is a value, that has comma's (,)","this has a ""quoted"" word","this is also a \"quoted\" word"
I can add an option to use a semicolon rather than a comma while importing .csv files.
What i want to know:
1. Do you also want to make the enclosure and the escape character to be modifyable?
2. Do you also want this for exporting wppa db tables?
Thread Starter
sbuwp
(@sbuwp)
Hello Jacob,
thank you for your quick reply and your comments.
It would be great if you could integrate an option that allows the semicolon as a separator for the CSV import. That would save me a lot of cyclic work. I only need the option for importing CSV files into Photo Album Plus. I also don’t need an option for other characters.
I want to feed Photo Album Plus heavily with external data that I manage in Excel (postcard albums). Here I have the problem that the German Excel version only generates the “;” as a separator.
If you could bring in the extension I would be very happy.
Best regards
Wolfgang
Pls install https://downloads.wp.xz.cn/plugin/wp-photo-album-plus.7.6.10.001.zip as explained here: https://wppa.nl/docs-by-subject/development-version/
From the changelog:
* New setting: Table IX-A19: CSV file separator. You can now select ; vs , for csv import and export.
Note that the change is both for import and export; for reasons of consistency.
Please test it and tell me if it works correctly (i could only test it partially)
Thread Starter
sbuwp
(@sbuwp)
Hello Jacob,
wonderful, I tested it and it works very good!
Thanks very much
Wolfgang
