Jump to content
Sign in to follow this  
cabsandy

Use Calcu fld to insert spaces into a number?

Recommended Posts

Hi,

I've tried this for about 3 hours and gave up in frustation-I have a 12 figure number (example is 112233445566)-I want to use FP to insert a space after every second number so I end up with 11 22 33 44 55 66.

This has to be done in the field so when I import the text file with the original info, the conversion is done automatically-other wise I have to do it in Excel-anybody got any ideas?

Sandy

Share this post


Link to post
Share on other sites

The calculation field has to be text output:

Left(myfield,2) & " " & Middle(myfield,3,2) & " " & Middle(myfield,5,2) & Middle(myfield,7,2) & " " & Middle(myfield,9,2) & " " Right(myfield,2)

Steve

Share this post


Link to post
Share on other sites

Try this calc.

Left(Number,2) & " " &

Middle(Number,3,2) & " " &

Middle(Number,5,2) & " " &

Middle(Number,7,2) & " " &

Middle(Number,9,2) & " " &

Right(Number,2)

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.

Sign in to follow this  

×
×
  • Create New...

Important Information

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