Crystal Reports Formula Help

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

Topic: Formula Help

Author	Message
Rodemusprime Newbie Joined: 19 Aug 2010 Online Status: Offline Posts: 10	Topic: Formula Help Posted: 13 Feb 2013 at 6:24am
	I have a field NUMBERS. that contains phone numbers. I need a formula that will search for the 4th number in that field, and if that number is either a "0" or a "1", I need it omitted. Otherwise I want the number shown. EX: 2120111234 2121111234 2125551234 I do not want my report to display the first 2 numbers.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 13 Feb 2013 at 6:43am
	not(mid({table.numbers},4,1) in ['1','0'])
	IP Logged

Rodemusprime Newbie Joined: 19 Aug 2010 Online Status: Offline Posts: 10	Posted: 13 Feb 2013 at 6:55am
	Thank you as always. It worked perfectly. I really need to learn this language.
	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.029 seconds.