Incrementing number in a text field

[scooby]

Hello,

I have a text field that holds a code like so "03-0528-1". The field is a standard text field so that I can allow the dashes. How can I increment the last number so that it becomes "03-0528-2" using insert calculated result(script)?

[-Queue-]

There is no need for an insert calculated result. Just use Set Field [textfield, Substitute( LeftWords( Substitute( textfield, "-", " " ), 2 ) & " " & NumToText( RightWords( Substitute( textfield, "-", " " ), 1 ) + 1 ), " ", "-" )].

This will convert the hyphens to spaces so the groupings can more easily be extracted, add 1 to the number furthest to the right, change it back to text, and convert the spaces back into hyphens.

Will this work for you?

[Riley Waugh]

If you have a text field, in defien fields under "options" under the 'auto-enter' tab, click serial number and put in the starting number...abc-123-2-2-1 or whatever.

[scooby]

thanks for the replies- this does not need to increment on every record, only on certain ones- so autoincrement wont suit my needs- i'll try the setfield option

thanks

[Ugo DI LUCA]

May be you should tell us :

1. What are the components of that key ?

2. What you want to use it for ?