Custom formating a field

[JohanA]

Hi all!

Have a new question.
Is it possible to make FM do custom formating in a field?

Like I have one field with numbers.
These number can vary but are 9 numbers long.

Let's say I have the number: 574318762
How can I make FM format that number like this: 574 318 762
I seems to be unable to find any options for that in the layout.

As always grateful for help

JohanA

[Lee Smith]

You will need to do that in a text field.

It’s call concatenate 

Left ( YourField ; 3 )  & " "  & Middle ( YourField ; 4 ; 3 )  & " "  & Right ( YourField ; 3 ) // if the source will always be 9 numbers

[JohanA]

16 minutes ago, Lee Smith said:

You will need to do that in a text field.

It’s call concatenate 

Left ( YourField ; 3 )  & " "  & Middle ( YourField ; 4 ; 3 )  & " "  & Right ( YourField ; 3 ) // if the source will always be 9 numbers

Big thanks, worked like a charm

[comment]

If you are using this as an auto-entered calculation replacing existing value, I would suggest you make it =

Let (
digits = Filter ( Self ; "0123456789" )
;
Left ( digits ; 3 )  & " "  & Middle ( digits ; 4 ; 3 )  & " "  & Right ( digits ; 3 )
)

Otherwise you will have problems editing an existing entry. For example, if you try and modify "111 222 333" to "444 222 333" you will end up with "444  22 333" instead.