1 Reply Latest reply on Oct 15, 2011 5:49 AM by LaRetta_1

    Help with field replace



      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.



        • 1. Re: Help with field replace

          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.