topic Re: Changing column format only for numeric ones via JSL in Discussions

Changing column format only for numeric ones via JSL

LogitTurtle576 — Fri, 09 Jun 2023 17:09:00 GMT

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.

jthi — Thu, 01 Sep 2022 08:10:03 GMT

Check Data type first with

<< Get Data Type

and compare it in If-statement

David_Burnham — Thu, 01 Sep 2022 12:22:08 GMT

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

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