Find & Replace Script

[bigedmustafa]

I am fairly new to FileMaker Scripting and would like to generate a script which would search a field containing people's last names, and have the script remove any hyphens, apostrophes, spaces etc., and replace them with nothing.

e.g. find "De La Cruz" and replace it with DeLaCruz, or O'neil to be replaced with Oneil.

Any guidance would be appreciated.

[-Queue-]

Show All Records

Freeze Window

Go to Record/Request/Page [First]

Loop

Set Field [LastName; Filter( LastName; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" )]

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

End Loop

[bigedmustafa]

cheers for that, works perfectly, although I did have to remove the "Freeze Window" in order for it to work.

[-Queue-]

That is odd. All Freeze Window does is keep the screen from updating as the loop progresses. It should work with or without it. What happened when you kept it in?