I'm trying to construct a simple script to clear a text field in the last 10 records of a 20-record table, but the script always clears the field in all of the records.

Enter Browse Mode []

Go to Record/Request/Page [No dialog; 11]

Loop

Replace Field Contents [No dialog; Table::Field; ""]

Go to Record/Request/Page [Next; Exit after last]

End Loop

This is my first attempt to use looping in a script, so I've obviously missed something very basic. I just haven't been able to locate a relevant example to get me on the right track.

The "replace field contents" step replaces everything in the found set.

Use your script and change "Replace Field Contents" to "Set Field[Table::Field; ""]

Hope that does it!

Although your loop will execute quite quickly you can still keep the script you are using but use the "omit records" script step to leave out he first 10 records and then use the replace.

Like I say 10 records is pretty quick, but 10,000 would be quite different.

Only a "heads up" on technique.

Thanks to you both. Things make a lot more sense now.