Replace last characters of a string dynamically

[Istwineres]

Hi, I have this string: 06SS0000000000 and I'd like to replace the last characters with count from the count records tool so: if 1 record counted the string should be 06SS0000000001 if 12 records are counted the string should be 06SS0000000012 if 123 records are counted the string should be 06SS0000000123. Thanks!

[Ladarthure]

I would do something like the formula below.

You can use record ID to add it and transform it to string via a select tool. 

Substring([Field1],0,Length([Field1])-1)+[RecordID]

[Istwineres]

Why -1 in substring?

[Luke_C · Accepted solution]

The -1 would drop the last character of the string off. If you wanted to drop however many characters are in the record ID off the end of the string just substitute the -1 with - length([RecordID]) 

[Istwineres]

yes, I did that way!