5 Replies Latest reply on Mar 12, 2013 8:11 PM by Lemmtech

    How do I use  a field calculation to add spaces in text string?

    jeremym

      Hi

       

      I am new to Filemaker and on a learning curve. I have a table of 1.6m records of zip (post) codes which are in one of two formats;

       

      Example;

       

      AB105TG

      NG3 6OP

       

      In the first one AB105GT I need to insert a space so that it becomes AB10 5GT. No changes are required to the other one. I have experimented using Left and taking the first 4 characters and putting those in a new field and then right for the last 3 and then using a calculation to paste them together with a space. It would be a lot better if I could have a calculation that does it in one go. I can't work out to do it. I assume if is going to be an If/Then/Else type arguement.

       

      Jeremy