ExifTool Forum

ExifTool => The "exiftool" Application => Topic started by: sevy on October 10, 2018, 03:11:32 PM

Title: csv file - sourcefile with backslash , not slash
Post by: sevy on October 10, 2018, 03:11:32 PM
Hello,

I'm working with windows 10.
I'm currently using ExifTool to generate csv files (with accentuated characters) with metadata of jpg files and it's working very well.
The first field is Sourcefile wich provide the full path and the filename with slash (x:/rep/rep1/file.jpg).
I was looking for a method to generate the csv file with backslash (x:\rep\rep1\file.jpg).
I tried with -api "Filter=s/\//\\/g" (found at https://exiftool.org/forum/index.php?topic=8507.0 , to be honest, I do not understand the syntax) ... but unfortunately, nothing happens.

does anyone have a suggestion in order to generate a csv file with backslash ?

thank you very much in advance,

sevy
Title: Re: csv file - sourcefile with backslash , not slash
Post by: StarGeek on October 10, 2018, 04:00:13 PM
I don't think you can change the Sourcefile column, since -api filter doesn't do it.

If you really need it changed I think your best bet would be to load it up in a spreadsheet and do a find/replace on the column.  Another alternative would be to include the Filepath variable, which is affected by -api filter, and then delete the Sourcefile column in a spreadsheet.

Does this CSV file need to be accessed by a tool other than exiftool?
Title: Re: csv file - sourcefile with backslash , not slash
Post by: sevy on October 11, 2018, 02:14:31 PM
Thanks for the reply.

The CSV file is used with another tool in order to find some value and finally open specific file.
I finally found a small program (FART - File And Replace Text) in command line mode. Very simple and useful.

So job is done :-)