Validate caracters 3

[jleboeuf]

Hi,

I want tu suppress a field if is not begin with 3 letters follow by 2 numbers ???

thanks Jean-Paul Leboeuf

jleboeuf@iquebec.com

 

[dgillz]

Do you want to suppress the field, or exclude the entire record from your report? These are totally different things. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[jleboeuf]

hi dgillz,

I want to suppres the field

i try to put in the suppress formula:
Not numerictext(Left(descr1),5) and NumericText(Mid(Descr1,4,2)

Looks like working but not for all the records

thx Jean-Paul Leboeuf

jleboeuf@iquebec.com

 

[synapsevampire]

The difficulty is the string check, the numeric is simple, your formula is close to checking if ALL of the characters are numbers, but not the first 3, and not individually, I can't recall if CR has an IsString (I'm not at a CR machine right now), I don't think so, so just use:

isnumeric(mid(Descr1,1,1))
or
isnumeric(mid(Descr1,2,1))
or
isnumeric(mid(Descr1,3,1))
or
not(isnumeric(mid(Descr1,4,2)))

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jleboeuf]

Hi,

I'm with CR 7 and the isnumeric doesn't seen working ??

thx Jean-Paul Leboeuf

jleboeuf@iquebec.com

 

[Naith]

Jean-Paul,

Replace IsNumeric with NumericText

Naith