Jump to content

Finding exact numbers in a certain position


richardb
 Share

This topic is 7465 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is there a way to find a range of numbers in a certain position within a particular record?

I wish to find records that have a number in the first 4 positions of the record, but not records which have numbers in other positions within the record.

Thanks

Link to comment
Share on other sites

Sorry. Should have made it clearer.

I have data with some records which have a number at the start eg. 443. The rest are text. I wish to find only records which have a number as the start of a particular field and not the text. But the number must be the start of the field, not somewhere else in it.

Link to comment
Share on other sites

try creating a calculated field called "Test" the calculation will be:

if(texttonum(left(Your Field,1))>0,"Num","Text")

Where "Num" is the true result of your choice, "Text" is the false result of your choice.

You could also use a Case function instead.

Link to comment
Share on other sites

This topic is 7465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.