Jump to content
JohanA

Custom formating a field

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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 :)

Share this post


Link to post
Share on other sites

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.

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

By using this site, you agree to our Terms of Use.