Omit records by IDlength

[young99]

is it possible to omit records from selection by the length?

An example:

ID
232
8284725
8323455
3
2242

I would like to only select records that are 7 digits long. I tried making some custom formulas but cant seem to get anything to work.

 

[lbass]

Use a record selection like this:

len({table.string})=7

Or if it is of number datatype, use:

len(totext({table.number},0,""))=7

-LB

 

[young99]

Thank you. I always over think things. This helped out!