Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Select letters in text field with numbers Post Reply Post New Topic
Author Message
mabrown
Newbie
Newbie


Joined: 08 Jun 2007
Online Status: Offline
Posts: 27
Quote mabrown Replybullet Topic: Select letters in text field with numbers
     Posted: 09 Jan 2013 at 3:38am
We have a text field that is mainly numbers with a few letters mixed in.  I want to select the records that actually have a letter in them.  How do I select them? The field length varies from 4 to 7 characters.  The letters can be in any position.

Here is some sample data:  Iwant to select the last three.

10202
10222.5
59874

1025T
45F64
A1234
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jan 2013 at 4:01am
not(isnumeric(field))
IP IP Logged
mabrown
Newbie
Newbie


Joined: 08 Jun 2007
Online Status: Offline
Posts: 27
Quote mabrown Replybullet Posted: 09 Jan 2013 at 4:53am
Very simple and it works great.

Thank you
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum