Print Page | Close Window

Formula Help

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19098
Printed Date: 04 May 2024 at 5:01pm


Topic: Formula Help
Posted By: Rodemusprime
Subject: Formula Help
Date 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. 


Replies:
Posted By: DBlank
Date Posted: 13 Feb 2013 at 6:43am
not(mid({table.numbers},4,1) in ['1','0'])

Posted By: Rodemusprime
Date Posted: 13 Feb 2013 at 6:55am
Thank you as always.  It worked perfectly.  I really need to learn this language.


Print Page | Close Window