I have numerous files where the year is listed as "2012-12-27". I want to trim this to only show the actual 4 digit year - "2012" for example.
I have tried the following:
This will trim everything after the first 4 digits for those files where the year is greater than 4 characters in length. However, when running this action, if it finds a file with only a 4 digit year, it is deleting it.
So, in the end, I want to be able to check the year field to see if it has more than for characters. If it does, I want to trim everything after 4 characters. If not... I don't want to edit it at all.
Can anyone please enlighten me on what I am doing wrong?
Many thanks in advance!!!