AnsweredAssumed Answered

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

Question asked by jeremym on Mar 11, 2013
Latest reply on Mar 12, 2013 by Lemmtech

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

Outcomes