clean up IPTC Description/Caption field

[frereroy]

We have a number of images that were annotated using Adobe Bridge and the person was a little careless in adding line feeds and/or carriage returns to the end of the Description/Caption field - usually after copy/pasting from a Word document.

Is there any way to clean up this field?

TIA

[Phil Harvey]

This command will remove trailing white space from the value for a TAG:

exiftool "-TAG<${TAG;s/\s+$// or $_=undef}" DIR

Here I have set the value to "undef" in the expression if there was no white space to remove.  This will give a warning, but will prevent a file from being rewritten if the tag wasn't changed.

- Phil

[frereroy]

Thanks Phil, but is not trailing white spaces that I am trying to kill but rather trailing linebreak characters.

[StarGeek]

White space characters are Line Feeds and Carriage Returns, as well as Spaces and Tabs.

Do need to only just remove the Line Feeds and Carriage Returns and keep trailing spaces?  Otherwise Phil's command above will work.

[frereroy]

Thanks, Yes I am using the following command on a Mac:

exiftool '-Description<${Description;s/\s+$// or $_=undef}' /Users/roy/Desktop/phil

Yes, the trailing spaces and linefeeds are indeed removed from the XMP but I would like them also removed from the embedded IPTC.

[StarGeek]

Add this to the command:
'-Caption-Abstract<${Caption-Abstract;s/\s+$// or $_=undef}'

[frereroy]

Many thanks. Works as expected.

[frereroy]

Please can you confirm that the following single command will update both IPTC and XMP fields.

It seems to work, but just would like to double check before launching it on 8.000 photos.

exiftool -use MWG '-Description<${Description;s/\s+$// or $_=undef}' -overwrite_original -r /Users/roy/Desktop/phil

TIA

[Phil Harvey]

?

Did you mean this command?:

exiftool -use MWG '-Description<${Description;s/\s+$// or $_=undef}' '-Caption-Abstract<${Caption-Abstract;s/\s+$// or $_=undef}' -overwrite_original -r /Users/roy/Desktop/phil

If so, then the answer is yes.  Otherwise, you were only writing the XMP:Description tag.

- Phil

[frereroy]

Thanks, works just fine. I was afraid that I may be overlooking something.

BTW, Information on the MWG tags is here:

https://exiftool.org/TagNames/MWG.html

(I have come across broken links in other threads).

[Phil Harvey]

(I have come across broken links in other threads).

If you tell me the threads I will fix the links.

Note that this is the official URL for this page:

https://exiftool.org/TagNames/MWG.html

- Phil

[frereroy]

The error is in the first message of this thread (misspelt .htmlt)
https://exiftool.org/forum/index.php/topic,9205.0.html

BTW, to only treat jpg files can I use:

exiftool -use MWG '-Description<${Description;s/\s+$// or $_=undef}' '-Caption-Abstract<${Caption-Abstract;s/\s+$// or $_=undef}' *.jpg -overwrite_original -r /Users/roy/Desktop/phil

TIA

[StarGeek]

Fixed link

[frereroy]

OK, I got it. (-ext JPG)

For Windows:

exiftool -ext JPG -use MWG "-Description<${Description;s/\s+$// or $_=undef}" "-Caption-Abstract<${Caption-Abstract;s/\s+$// or $_=undef}" -overwrite_original -r /Users/roy/Desktop/Photothèque

[frereroy]

Is there a switch that will allow parsing accented directory names in Windows 7 West european?

TIA