Selecting a record if it contains a number.. 1

[rji1124]

Hi - we are on CR 9... I would like some help with how I would go about selecting records that contain a number in the field. We have a field called updated.by... in the last 203 positions of some of the IDs in this field have a number (like xyz01 or zzz123. Some of the IDs do not have the numeric ending. I would like to pull only the IDs that have a number at the end.. so I am thinking I only need to look at the last character in the updated.by field and determine if it is a numeric or not... if it is, I want to report on it.. if it isn't - ignore it.
Thanks for any help...

 

[AndyMc]

rji1124,

try adding this to your record selection:

NumericText(right({table.updated.by},1)) = true

Andy

 

[rji1124]

BAM! Thanks Andy - that was perfect...