I have a solution with about 1800 records in it. I have just recently added a validation to 10 of the fields so that they can each have only 8 characters. Is there a way I can go through the existing records and find/remove the extra characters that were there before I created the validation? Does the Trim function do this?

Thanks.

Susan

You can loop through all records and test whether Length(field1) > 8 or Length(field2) > 8, etc.

Show All Records

Freeze Window

Go to Record/Request/Page [First]

Loop

If [Length(field1) > 8 or Length(field2) > 8 or ... or Length(field10) > 8]

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

Else

Omit Record

End If

Exit Loop If [not Status(CurrentFoundCount)]

End Loop

Go to Record/Request/Page [First]

Now you can manually navigate through the found set and remove extra characters as necessary. You could script the removal of extra characters, but it's safer if you verify the change visually.

Thanks for the script... it worked like a charm. And taught me about the Length function :-)

Susan