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

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

cnattrass — Wed, 23 Oct 2019 21:20:40 GMT

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)

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

cnattrass — Wed, 23 Oct 2019 23:09:20 GMT

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"};

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

PatrickGiuliano — Thu, 24 Oct 2019 04:47:28 GMT

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?

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

Mark_Bailey — Thu, 24 Oct 2019 13:29:09 GMT

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

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

Mark_Bailey — Thu, 24 Oct 2019 13:29:55 GMT

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