AnsweredAssumed Answered

Searching and clearing  contents of repeating fields

Question asked by ambrosiasw on Aug 4, 2010
Latest reply on Aug 4, 2010 by philmodjunk

Title

Searching and clearing  contents of repeating fields

Post

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. 

Outcomes