Jump to content
Sign in to follow this  
richardb

Finding exact numbers in a certain position

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

Share this post


Link to post
Share on other sites

Call me dense, but are you referring to record or field?

i.e. does a numeric character exist in the first 4 characters of the field contents. crazy.gif" border="0

Share this post


Link to post
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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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