turn middle overcard to the flop
Posted: Mon May 24, 2021 7:48 am
Hello,
i have a problem when i would like to make an expression filter.
My goal is that i would like to search that hand where flop is paired and the kicker is not bigger than 7. I could make it:
((tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_2 % 13
AND tourney_hand_summary.card_3 % 13 BETWEEN 1 AND 6)
OR (tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_3 % 13
AND tourney_hand_summary.card_2 % 13 BETWEEN 1 AND 6)
OR (tourney_hand_summary.card_2 % 13 = tourney_hand_summary.card_3 % 13
AND tourney_hand_summary.card_1 % 13 BETWEEN 1 AND 6))
than i would like to filter that hands where the TURN card is higher than the flop middle over card (for example: flop is 733 and the turn have to be between 4 and A.
But i cant set that how i can identify which is the middle card on the flop in this case the 3. (its just an example but it coud be 266 where the middle is 2 and the turn have to be between 3 and A.
please help me the make it.
Thx.
i have a problem when i would like to make an expression filter.
My goal is that i would like to search that hand where flop is paired and the kicker is not bigger than 7. I could make it:
((tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_2 % 13
AND tourney_hand_summary.card_3 % 13 BETWEEN 1 AND 6)
OR (tourney_hand_summary.card_1 % 13 = tourney_hand_summary.card_3 % 13
AND tourney_hand_summary.card_2 % 13 BETWEEN 1 AND 6)
OR (tourney_hand_summary.card_2 % 13 = tourney_hand_summary.card_3 % 13
AND tourney_hand_summary.card_1 % 13 BETWEEN 1 AND 6))
than i would like to filter that hands where the TURN card is higher than the flop middle over card (for example: flop is 733 and the turn have to be between 4 and A.
But i cant set that how i can identify which is the middle card on the flop in this case the 3. (its just an example but it coud be 266 where the middle is 2 and the turn have to be between 3 and A.
please help me the make it.
Thx.