zipcode report -finding the bad ones

[andreadd]

CR2008 Visual Advantage, SQL 2000 SP4

Hello,

I am writing a report that is using graphics to flag records that are missing information like phone number. I am using a formula in supression to get the graphic to change based on what i am looking for. To find totally missing data it is working far better than I planned however I have a new task for zipcodes. Turns out we have many that do not have the 5 digits that the USPS need. I need to alter my current formula {CONTACT1.ZIP} <> '' to also include and if not 5 digits long. I poked around in formula builder and didnt easily see a function for length - if blah.field is X' in length.

is there something like that?

thanks

 

[Turkbear]

Hi,
Try the Length() function:

If (IsNull({CONTACT1.ZIP}) or Length({CONTACT1.ZIP}) < 5) then
.....

Note : If ZIP is a Numeric field rather than text, then use:
Length(ToText({CONTACT1.ZIP}))





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Tatertot45]

Have you tried "Length"? If Functions, go to Strings, then look for "length". You may need to mess with your Zipcode formats, but that would be a good start.

 

[andreadd]

I was able to take your suggestions and figure out what I need

thanks a bunch for the help!!!!!