[validation request] Fold to F Float 3betp

[js2002]

cnt_f_float_def_opp_action_fold_3betp
sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XF' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])
------------------------------
cnt_f_float_def_opp_3betp
sum(if[lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

1. looks correct?
2. for the 2 other reaction: call and raise, can I simple build them like that:

a) cnt_f_float_def_opp_action_call_3betp
sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XC%' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

I guess there is a problem with XC% string right? Or is it ok/like u would do it?
I saw u use "XC" only, why?
With "XC" the line XCC for example wont count!


b) cnt_f_float_def_opp_action_raise_3betp
sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR%' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

same here, ok?
Please react on 1,2a and 2b.

[kraada]

(1) Yes.

(2) (a) Yes, that will work. There will only be a third action in very unusual multi-way pots (You check, someone bets, you call, someone else behind you raises, or you check, someone bets, someone raises, you call, someone else 3bets). You will find these to be extremely rare no matter what game is being played.

(b) Yes, this will work as well. Regarding the %, the same considerations are true here, though in theory it is probably a bit more common to get shoved on and have a chance to call (but still if the pot is 4bet and you check/raise it's unlikely anybody has anything left behind).

[WhiteRider]

This:

substring(lookup_actions_f.action from 1 for 2) = 'XC%'

..will not work correctly.

substring( str from 1 for 2 ) will return a 2-character string, and the string you're comparing it to has 3 characters so they will never match.
You should use this:

substring(lookup_actions_f.action from 1 for 2) = 'XC'

Spoiler: show

substring(lookup_actions_f.action from 1 for 2) LIKE 'XC%' would work, but is unnecessary. The point of substring is to get the exact characters you're interested in.

[js2002]

I did.
for the future: whats the exp to catch all CRCRCR.... so CR% ?

[kraada]

Substring gets exactly two characters in this case. If you take the substring from 1 for 2 of "CRCRCRCR" you still get just "CR".

That said if you used LIKE instead of = it would still match your pattern the % can mean 0 or more, but only when used with LIKE, not with =.

[js2002]

I see, Iforget the syntax all the time after pauses. thx