I’m using a Table DAT where some rows have fewer columns filled in than others. I would like to select different rows of this Table, and then filter out any column that is empty or contains anything other than digits 0-9.
When I manually test the match expression on each column value for a particular row in the python shell, the result is different than what the Select DAT is returning. Attached is a .toe that hopefully demonstrates this. To me the behavior seems inconsistent, so I’m lost as to where I’m going wrong.
If there is a more elegant way to achieve the behavior I am going after, I would be interested in that as well!
brokenselectdat.toe (4.4 KB)