Return to FileMaker.com
Create Spaces In A Field
I just wanna know how to create spaces between numbers in one field. So I want this - 456899233, to look like this - 456 899 233.
Then this should not be a number field but rather text. and you could change data or prefer to create a calculation with
Left(field;3) & " " & Middle(field;4;3) & " " & Right(field;3)
if the field ever contains anything else but numbers or a different number of numbers then we will have to make adjustments.
Retrieving data ...