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;
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.