Return to FileMaker.com
Moving some contents of a field into another field
Have two fields; Address1 and Address2. I want to move some of the data from Address1 into Address2. Is there an easy way to do this.
For example: In Address1 we have 2055 Ocean Avenue, Apt 9. I want to move Apt. 9 to Address2 and delete the , Apt. 9 from Address1
Your help is greatly appreciated.
I think you would need to use the "position" function to find the comma then set Address2 to everything after the comma then Address1 to everything before the comma.
Retrieving data ...