nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

280721_en-US

liliconcom

recognize (guess) the format of the column with help of JSL

Is there a stand-alone function in JSL to recognize the data format of a column?

@martindemel

Advanced Statistical Modeling

Automation and Scripting

Mass Customization

Re: recognize (guess) the format of the column with help of JSL

This is a feature request now.

https://community.jmp.com/t5/JMP-Wish-List/Force-best-guess-to-change-data-types/idc-p/652388#M4512

Re: recognize (guess) the format of the column with help of JSL

There isn't a function to rerun the Best Guess option. However, it would be a very simple matter that after you have gotten dealt with the Waste rows, to save the table as a .csv in the $TEMP folder, and then read it back in, which then JMP would reapply the Best Guess option.

Re: recognize (guess) the format of the column with help of JSL

I need to give more information to understand my question.

In case I read a csv file, JMP is able to guess data type.

However, my csv files contains several rows with "waste" until the data rows come.

I need this waste to generate appropriate column names of them. I don't want to skip these rows.

JMP doesn't recognize the "real" format of the column with this "waste" in the rows before data.

I want JMP to analyze column again and assign the data type by "Best Guess" afterwards.

Does the command " get format" do this job for my purpose?

I guess it gives me the actual data format.

Re: recognize (guess) the format of the column with help of JSL

Use the Get Format message

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

xx = dt:height << get format;