Text only | Text with Images

ExifTool Forum

ExifTool => Newbies => Topic started by: thaddeusf on May 28, 2020, 11:28:03 PM

Title: Need to add quotes when exporting metadata to CSV
Post by: thaddeusf on May 28, 2020, 11:28:03 PM
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!
Title: Re: Need to add quotes when exporting metadata to CSV
Post by: StarGeek on May 28, 2020, 11:42:00 PM
Is there any reason you're not using the -csv option (https://exiftool.org/exiftool_pod.html#csv-CSVFILE)?  It will take care of the quotes if they are needed.
exiftool -Description -CreateDate -Title -Source -csv *1925*.* >Chronological.csv
Title: Re: Need to add quotes when exporting metadata to CSV
Post by: thaddeusf on May 29, 2020, 02:32:30 PM
The reason is because I'm an idiot. Was making this much more complicated than needed.

Thanks StarGeek
Text only | Text with Images