Newbies bigedmustafa Posted January 20, 2005 Newbies Share Posted January 20, 2005 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. Link to comment Share on other sites More sharing options...
-Queue- Posted January 20, 2005 Share Posted January 20, 2005 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 Link to comment Share on other sites More sharing options...
Newbies bigedmustafa Posted January 21, 2005 Author Newbies Share Posted January 21, 2005 cheers for that, works perfectly, although I did have to remove the "Freeze Window" in order for it to work. Link to comment Share on other sites More sharing options...
-Queue- Posted January 21, 2005 Share Posted January 21, 2005 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? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7033 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now