You may want to enhance that filename rule to something like:
Clean(RemoveCharacters(left([name], 8
), ., 3))
Which trims to eight characters, removes leading and trailing ".", and then removes empty () and [], superfluous dash (-) and whitespace characters and sometimes comma. That will see you with less than eight characters sometimes, but without trailing spaces or full stops, which might be bad.
Of course, a regex expression, or an improvement on the above, may be better. Perhaps remove the space etc. first;
RemoveCharacters(left(Clean([name]), 8
), ., 3))
Or if you always want eight characters;
left(RemoveCharacters(Clean([name]), ., 3), 8
)
Also, you may want to include other characters in the RemoveCharacters() command, such as ellipses (…) which are very bad at the end of a file name.
References. Read thoroughly and understand:
https://wiki.jriver.com/index.php/Rename,_Move,_and_Copy_Fileshttps://wiki.jriver.com/index.php/Expression_Language