ExifTool Forum

ExifTool => The "exiftool" Application => Topic started by: DocDJ on February 04, 2023, 09:01:33 AM

Title: CSV not producing commas as delimiter
Post by: DocDJ on February 04, 2023, 09:01:33 AM
The EXIFTOOL documentation says that comma is the default for -csv delimiter, but it isn't happening for me.
I have tried using -csv alone as well as -csv -csvDelim , but neither of them gives me the comma. I always get a tab for a separator. I have also tried using -T with and without the csvDelim , and still cannot get the comma.

In all cases, I am using " -W+! " because I am running EXIFTOOL as a process in Windows using CreateProcess and > is only processed by the shell. And yes, I DO want the file overwrite.
Title: Re: CSV not producing commas as delimiter
Post by: Phil Harvey on February 04, 2023, 09:13:29 AM
The -csv option is not compatible with -W.

And please test your commands on the command line so you can see any error/warning messages before trying to run them from some other app.

- Phil
Title: Re: CSV not producing commas as delimiter
Post by: StarGeek on February 04, 2023, 10:07:50 AM
If you had tested the command, you would have seen this output.
C:\>exiftool -csv -W+! %d%f.txt -filename y:\!temp\Test4.jpg
Sorry, -w may not be combined with -csv
Title: Re: CSV not producing commas as delimiter
Post by: DocDJ on February 04, 2023, 10:27:00 AM
Thanks. Is there a way to get the -T option to use commas instead of tabs (with the -W option)? I think that the documentation would be a good place to mention restrictions about -W. When working on a program, I try to rely strictly on documentation, examples and experimentation using the actual code in the program I am writing. I have found that, with many dual platform programs, if things work on the command line (such as ">"), I might be led to believe that they work in code (because I would think they would be passed to EXIFTOOL to be processed with the other parameters), which has proven to be false.

If I'm stuck with tabs, I will have to parse for them instead of commas, which is not a big deal. And I still LOVE EXIFTOOL.
Title: Re: CSV not producing commas as delimiter
Post by: StarGeek on February 04, 2023, 10:32:30 AM
Quote from: DocDJ on February 04, 2023, 10:27:00 AMI think that the documentation would be a good place to mention restrictions about -W.

From the docs on the -csv option (https://exiftool.org/exiftool_pod.html#csv-CSVFILE)
    Also, it makes this option incompatible with the -w option
Title: Re: CSV not producing commas as delimiter
Post by: Phil Harvey on February 04, 2023, 10:35:06 AM
Quote from: StarGeek on February 04, 2023, 10:32:30 AMAlso, it makes this option incompatible with the -w option

I'll change this to "-w and -W".

- Phil
Title: Re: CSV not producing commas as delimiter
Post by: DocDJ on February 04, 2023, 10:40:09 AM
Thanks.