Crystal Reports Select non numbers from text field

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Select non numbers from text field

Author	Message
mabrown Newbie Joined: 08 Jun 2007 Online Status: Offline Posts: 27	Topic: Select non numbers from text field Posted: 13 Jul 2017 at 7:00am
	We have a text field that contains mostly numbers but we want to select the records that contain a mix of numbers and letters (no records have all letters). Examples of data. 0001A D0002 0202P Z0678 01234 52476 99875 How do we select records like the first 4. Thank you.
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 13 Jul 2017 at 7:54am
	if not(isnumeric({somefield})) then {somefield} (unless this is for selection criteria, then after the then put true).
	IP Logged

mabrown Newbie Joined: 08 Jun 2007 Online Status: Offline Posts: 27	Posted: 13 Jul 2017 at 8:33am
	That does it thank you.
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.016 seconds.