7 Replies Latest reply on Mar 15, 2016 9:53 AM by sudha

    Left and Right syntax for renaming the file name


      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