257255_en-US

liliconcom

How do I check that a column contains only integers?

Hello,

 

I need to check that a column contains only integers before running the rest of my script but I don't know how to do that. Ideally I would like to be able to identify precisely the rows with decimal values.

 

Thanks in advance for your help!

Re: How do I check that a column contains only integers?

What a beautiful solution!! Thanks @Mark_Bailey 

Re: How do I check that a column contains only integers?

See the last line.

Names Default to Here( 1 );

// generate test case with a mix of 90% integers and 10% non-integers
data = J( 30, 1,
 If( Random Uniform() < 0.1,
  Random Normal(),
  Random Integer( -6, 6 )
 );
);

// check results
Show( data );

// make a data table example
dt = New Table( "Test Cases",
 New Column( "Data", Numeric, Continuous,
  Values( data )
 )
);

// now the solution
nonIntegersHere = dt << Get Rows Where( Modulo( :Data, 1 ) );