csv file - sourcefile with backslash , not slash

[sevy]

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

[StarGeek]

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?

[sevy]

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 :-)