topic Re: how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -thanks in Discussions

how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -thanks

Andreas_Goller — Fri, 09 Jun 2023 17:08:18 GMT

how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -than

Re: how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -thanks

txnelson — Tue, 23 Aug 2022 15:19:28 GMT

Select the columns you want to change the format to, then go to the pull down menu

Cols=>Standardize Attributes

and you will be able to set the format once and it will apply it to all of the selected columns.

Re: how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -thanks

Georg — Wed, 24 Aug 2022 05:54:15 GMT

In addition to interactive way of Jim, to do it as a Script see the following example:

Names Default To Here( 1 );
// define a column group and set format of that columns in the group

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
dt << group columns( "decimals", {:height, :weight} );

For Each( {value}, dt << get column group( "decimals" ),
	Print( value );
	value << Format( "Fixed Dec", 15, 3 );
);

Re: how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -thanks

Andreas_Goller — Wed, 24 Aug 2022 06:10:43 GMT

Thanks for your help