Searching and clearing contents of repeating fields
I posted earlier in regards to a project I am working on to move data from our old database to our new one, which doesn't contain any repeating fields. But before I can be done with this fields forever I have to move this data. My question now is, is there a way to script FileMaker to search my product repeating field using the rightwords function to find values that aren't numerical, then clear the field? Anything in the field that ends in a version number (i.e. 1.0.10) I want saved, any entries in the field that end in words or letters I want cleared.