suppress if the 6th character equals -0- 2

[Monkey820]

Hi There!

I need a formula to suppress the field if the 6th character in the field equals -0-. How do I formulate it to only look at that 6th character?

Any help is appreciated!

Thanks!

Micky
CRW 8.5
WindowsXP

 

[lbass]

In what sense is that the 6th character? It looks like characters 6,7 and 8 or maybe 5,6,7--or are you trying to mimic another odd character by using -0-? Try using the mid function:

mid({table.field},6,3) = "-0-" //if it is the 6th thru 8th

The first number shows the starting position, and the second indicates the number of characters.

-LB

 

[Monkey820]

The 0 is just a 0 , no dashes (sorry)
Your information helped! Thanks!

 

[chelseatech]

You could also use the subscript operator for a smaller faster formula...
{table.field} [6] = "0"

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[CR85user]

I like that Chelsea - Cheers for the tip.

J

 

[Madawc]

I tried {table.field} [6] = "0" and got a syntax error. What am I doing wrong?

Madawc Williams (East Anglia, UK)

 

[Turkbear]

Hi,

Works for me..In the
Supress formula editor

{table.field} [6] = "0"

does supress the expected fields...






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

 

[synapsevampire]

Madawc: If you receive an error, post the specific error that you're getting.

I'd guess that you tried it against a non string field, or it's a memo field.

-k

 

[Madawc]

Sorry, it was indeed non-string. The numeric code worked fine with Totext({Cusomter.CustNo}) [2]

Madawc Williams (East Anglia, UK)

 

[Monkey820]

OK - Now I need to suppress everything that does not start with 1, 2 or 3 in the first position of a string field.


Any help?

Micky
CRW 8.5
WINXPPRO

 

[lbass]

You could use a suppression formula of:

{table.field}[1] in ["1","2","3"]

Or, you could use:

left({table.field},1} in ["1","2","3"]

-LB

 

[Monkey820]

Will this suppress 1, 2 and 3? I need to see only 1, 2 and 3.

 

[lbass]

Sorry, I had it backwards:

not({table.field}[1] in ["1","2","3"])

OR, use:

not(left({table.field},1} in ["1","2","3"])

-LB

 

[Monkey820]

Ahh! I used
left({table.field},1) in ["1","2","3"]
and then got a true, false value, so I suppressed the false.

Is that an acceptable way to get my result or is it too messy?

 

[lbass]

Where are you using this? I meant for you to use this in the format field->common->suppress->x+2 formula area--assuming you want only to suppress the field itself. If you wanted to suppress the entire row, you would use the formula in the section expert->details->suppress->x+2.

-LB

 

[Monkey820]

Excellent!! Thank you very much!!

 

[Siggy19]

Depending upon why you are doing this, you may want to consider putting the criteria in the select statement so that you only get the records that you want... where possible, let the database do the work for you - that's what it's designed for.