Left and Right syntax for renaming the file name

Discussion created by sudha on Dec 4, 2015
Latest reply on Mar 15, 2016 by sudha

Hi All,


I have a file with the name Sample.doc. The requirement is to rename the file to Sample1.doc if duplicate file names are present.


Please suggest me how to use the Left and Right syntax in the calculation field to extract filename before the dot(Sample), appending numbers like (1,2,....) and then again appending the extension which is present after dot