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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Who Viewed the Topic

    1 member has viewed this topic:
    Terrible Toll 
×
×
  • Create New...

Important Information

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