Changing column format only for numeric ones via JSL

[#1]

Hi,

I can't figure out how to change the format for all numeric columns in my table to be with just 2 dec. via JSL.

The following code is sending errors because it tries to do it for non numeric columns too.

For( i = 2, i <= N Col( dt ), i++,
    Column( dt, i ) << Format( "Fixed Dec", 12, 2 )
);

Thanks in advance for any help.

[#2 · Accepted solution]

Check Data type first with

<< Get Data Type

and compare it in If-statement

[#3]

FYI, you can also get a list of only numeric columns

lst = dt << get column names(numeric);