Using Variables in Replace Field Contents?

[uemtux]

Let's say I have a found set of say 50 records, I want to set serial numbers for these records starting with $initialpos

So I put the "Replace Field Contents" step into my script.

I select "Replace with Serial numbers" - in initial value I put $initialpos, and in "increment by" I put 1.

The script actually puts the text "$initialpos" into the first record. Subsequent records are "$initialpos1, $initialpos2" etc.

How can I get this script step to work like it should?

If I have to page through every record and set script-calculated serial numbers I will, but I hope there's a better solution than that!

Thanks!

P.S The one thing I did try was putting double quotes around the variable name. No joy. Still didn't work.

Edited April 29, 2010 by Guest

[bruceR]

I think you'll have to use the calculated result option instead:

$initialpos + get( recordNumber) - 1

[uemtux]

Thank you Bruce, that worked perfectly!