Choose Language Hide Translation Bar
Highlighted
cnattrass
Level II

How do I preserve trailing zeros in a list of numbers?

Hey guys, 

 

I have an application where I need to preserve trailing zeroes for numbers within a list when using the round function. I know trailing zeroes can be preserved in column formatting but the numbers I am working with exist outside of a column object.

 

An example below

 

list_x = {23.04, 24.12,59.632,87.9913};
rounded_x = {};
for(i = 1, i <= nitems(list_x), i++,
	rounded_x[i] = round(list_x[i], 1);
);

show(rounded_x);

The returned list does not show trailing zeroes 

 

rounded_x = {23, 24.1, 59.6, 88};

I looked for ways to force something to a float with specific decimal places but couldnt find anything in the scripting index (at least for the keywords I was using)

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
cnattrass
Level II

Re: How do I preserve trailing zeros in a list of numbers?

Landon a coworker of mine and a JMP guru was able to answer the question

 

Here is the solution if anyone else had this question 

 

list_x = {23.04, 24.12,59.632,87.9913};
rounded_x = {};
for(i = 1, i <= nitems(list_x), i++,
	rounded_x[i] = eval(expr(format(round(list_x[i], 1), "Fixed",1)));
);

show(rounded_x);

Returns

rounded_x = {"23.0", "24.1", "59.6", "88.0"};

 

View solution in original post

4 REPLIES 4
Highlighted
cnattrass
Level II

Re: How do I preserve trailing zeros in a list of numbers?

Landon a coworker of mine and a JMP guru was able to answer the question

 

Here is the solution if anyone else had this question 

 

list_x = {23.04, 24.12,59.632,87.9913};
rounded_x = {};
for(i = 1, i <= nitems(list_x), i++,
	rounded_x[i] = eval(expr(format(round(list_x[i], 1), "Fixed",1)));
);

show(rounded_x);

Returns

rounded_x = {"23.0", "24.1", "59.6", "88.0"};

 

View solution in original post

Highlighted

Re: How do I preserve trailing zeros in a list of numbers?

How can I modify this easily in the context of a much larger "custom list"? For example, N rows of values exported (populated) into a JMP data table Column?
Highlighted

Re: How do I preserve trailing zeros in a list of numbers?

If you want to retain numeric values, just send the message to the data columnn to set this format.

Learn it once, use it forever!
Highlighted

Re: How do I preserve trailing zeros in a list of numbers?

The original script returned numeric results from the Round() function. The solution returns character string results from the Format() function.

Learn it once, use it forever!
Article Labels

    There are no labels assigned to this post.