cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Bo
Bo
Level II

How to represent numeric value "1" as "001"?

I have thousands of X and Y coordinates in two different columns and would like to combine the coordinates as 6-digit values into a single column. For example, combine (1,1) into 001001, and combine (14, 14) into 014014. A simplified data table is attached.

How do I do that using formula or script?

Bo
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to represent numeric value "1" as "001"?

Assuming X and Y never exceed three digits, this should work in a column formula:

Repeat( "0", 3 - Length( Char( :X ) ) ) || Char( :X ) ||

Repeat( "0", 3 - Length( Char( :Y ) ) ) || Char( :Y )

Edit:

Or maybe this is more efficient:

Right( Char( 1e6 + :X * 1e3 + :Y ), 6 )

View solution in original post

5 REPLIES 5
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to represent numeric value "1" as "001"?

Assuming X and Y never exceed three digits, this should work in a column formula:

Repeat( "0", 3 - Length( Char( :X ) ) ) || Char( :X ) ||

Repeat( "0", 3 - Length( Char( :Y ) ) ) || Char( :Y )

Edit:

Or maybe this is more efficient:

Right( Char( 1e6 + :X * 1e3 + :Y ), 6 )

Bo
Bo
Level II

Re: How to represent numeric value "1" as "001"?

Thanks. Exactly what I want.

Bo
Jeff_Perkinson
Community Manager Community Manager

Re: How to represent numeric value "1" as "001"?

You can use the Repeat() function to pad out the character representation for these coordinates.

It would look like this:

8053_JMPScreenSnapz001.png

(Repeat( "0", 3 - Length( Char( :X ) ) ) || Char( :X )) || (

Repeat( "0", 3 - Length( Char( :Y ) ) ) || Char( :Y ))

I've attached your data table with a new column showing this.

-Jeff

-Jeff
Bo
Bo
Level II

Re: How to represent numeric value "1" as "001"?

Thank you for the fast response.

Bo
Craige_Hales
Super User

Re: How to represent numeric value "1" as "001"?

the left and right functions have a third argument to specify a pad value.  JSL Character String Functions

x=42;

right( char(x), 3, "0");

"042"

be careful, some of the other suggestions may be more robust if the numbers are out-of-bounds, or maybe not, depending what you expect:

x=9876;

right( char(x), 3, "0");

"876"

Craige