topic Re: sélection de lignes in Discussions

sélection de lignes

hcarr01 — Thu, 08 Jun 2023 16:30:38 GMT

Je cherche comment sélectionner les lignes dont l’avant dernier chiffre est 4, par exemple sélectionner la ligne qui a pour valeur « 23546 »

Re: sélection de lignes

Jed_Campbell — Wed, 08 Mar 2023 15:27:03 GMT

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.

Re: sélection de lignes

txnelson — Wed, 08 Mar 2023 15:34:52 GMT

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" );

Re: sélection de lignes

Craige_Hales — Wed, 08 Mar 2023 17:33:31 GMT

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!