line selection

[#1]

I am looking for how to select the rows whose penultimate digit is 4, for example select the row which has the value "235 4 6"

[#2]

One way to do this would be to grab the left-most digit of the right-most 2 digits, then see if it is 4. Then, select the rows where this formula returns a 1. Sample table attached.

[#3 · Accepted solution]

Here is a simple example that selects the rows where the penultimate digit is 4

Names Default To Here( 1 );
dt = New Table( "hcarr01",
	add rows( 100 ),
	New Column( "example", set each value( Random Integer( -1000, 1000 ) ) )
);

// This is the selection statement to select the rows whose penultimate digit is 4
dt << select where( Substr( Char( :example ), -2, 1 ) == "4" );

[#4]

It's good to have choices. Here's one that avoids the string conversion.

dt << select where( 40 <= Mod( Abs( :example ), 100 ) < 50 );

You might prefer one of the others that uses conversion to string because...well, if Jim hadn't included negative numbers, I'd have left out the abs(...).

@DonMcCormack - challenge!