I have a database with > 1600 records. I need to use the strip( function on a field (Writer2) for all 1600+ records. I tried using a procedure with a keyboard shortcut and do this one field at a time but I’d like to do it in one operation, if possible.
My function is: Writer2 = strip(Writer2)
I think you meant to say, you tried doing it one record at a time.
The procedure you are looking for is
field Writer2
formulafill strip(Writer2)
Yes, you are correct one record at a time. I did < 1 in the time it took with the procedure you wrote. I appreciate it.
I had a field Writer (lastname, firstname) that I converted to Writer2 (firstname lastname). I was able to use “Split” and “Merge” but just couldn’t finish that last step of getting rid of spaces at the beginning.
Again, thank you (and thanks for the prompt response). I’ll keep the formulafill statement in my toolbox for future use.
For future reference, you could also do this with the Morph dialog, using the Strip Surrounding Blanks operation. No code required.
Wow. That is such a powerful tool. Thank you.