News:

2023-03-15 Major improvements to the new Geolocation feature

Main Menu

Need to add quotes when exporting metadata to CSV

Started by thaddeusf, May 28, 2020, 11:28:03 PM

Previous topic - Next topic

thaddeusf

Hello again,

I've read the document https://exiftool.org/exiftool_pod.html#Input-output-text-formatting, but I'm still having difficulties adding quotes to the output of metadata.  The command I'm using:

exiftool -Description -CreateDate -Title -Source -T *1925*.* >Chronological.csv

Unfortunately many of the descriptions contain commas and it is messing up the comma delimited csv. I've tried a number of things based on the formatting document, but am not finding a solution.

Any advice?
Thanks!

StarGeek

Is there any reason you're not using the -csv option?  It will take care of the quotes if they are needed.
exiftool -Description -CreateDate -Title -Source -csv *1925*.* >Chronological.csv
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

thaddeusf

The reason is because I'm an idiot. Was making this much more complicated than needed.

Thanks StarGeek