Help with field replace
Hi guys ,
I developed solution from filemaker and i just imported excel file in to the databse. Originally the excel file have field called "postal code" and the data looks like "1234". Now Filemaker also show the same as excel file. But that is not the problem:)
All i want to do convert "1234" in to "01234" on filemaker. This database go to replace the exsisting database.
How can i9 acomplish this ? Thanks in advance for your help.
*so will import records from old database and enter data manually.
Try: Right ( "00000" & yourZip ; 5 )
Back up first. Be sure the zip is text in FileMaker and then show all records. Place cursor in zip field (do this while not being served or when nobody is in system) and then Records > Replace Field Contents > Replace with calculated result and put this calc in the calc box. Say OK and then REPLACE.