SUBSTRING ?

[stuart_gall]

Hello,
Reading the Custom stats and reports guide. There is a SUBSTRING function mentioned.
This function does not seem to work in Column or Statistic. And it is not listed when I click the INSERT button.

Does it Exist or not ?


Stuart.

[kraada]

It worked last I checked. You want to use it inside another statistic and something like: substring(lookup_actions_r.action from 1 for 1) = 'C' will match times a player's first river action is call (and anything else may or may not happen afterwards).