create 'mytable2','name'
put 'mytable2','row1','name',' 123456 '
put 'mytable2','row1','name',' 1234567 '
put 'mytable2','row1','name',' 12345 '
scan 'mytable2'
scan 'mytable2',{COLUMNS=>'name:',FILTER=>"(SingleColumnValueFilter('name','',=,'regexstring:.*7',true,true))"}
put 'mytable2','row1','name',' 123456 '
put 'mytable2','row1','name',' 1234567 '
put 'mytable2','row1','name',' 12345 '
scan 'mytable2'
scan 'mytable2',{COLUMNS=>'name:',FILTER=>"(SingleColumnValueFilter('name','',=,'regexstring:.*7',true,true))"}