"Left" function in color callout

[kiler40]

Hi Everybody,

I`m trying to add Left function to a color callout, but for some reason nothing is happening.
Can you please help me a little-bit.

In the example i have 3 color callout. And in the shape sheet if i change first one that says

Code Select Expand

STRSAME("r",Prop.Row_1,TRUE)

and change it to

Code Select Expand

STRSAME(LEFT(Prop.Row_1,1)="r",Prop.Row_1,TRUE)

OR JUST

Code Select Expand

STRSAME(LEFT(Prop.Row_1,1),Prop.Row_1,TRUE)

It seems nothing to happen.... the box turns white.

Can you please tell me what i`m doing wrong...

Thank you in advance

[Surrogate]

what value may be in prop.row_1 ?

look about STRSAME function syntax there

[kiler40]

Value will be for example "R/W" of "R/G" or "R/whatever"

But the important symbol is "R"

[Surrogate]

STRSAME determines whether strings are the same. It returns TRUE if they are the same and FALSE if they aren't. To compare multi-byte strings or to do comparisons using case rules for a specific locale use the STRSAMEEX function.

in this case you are always get FALSE in these formulas. Because one left symbol never be same as long strings (for example "R/W" of "R/G" or "R/whatever")

[kiler40]

It seems that i`m not changing the right thing. I have to change

Prop.Row_1
to
LEFT(Prop.Row_1,1)

Code Select Expand

STRSAME("r",LEFT(Prop.Row_1,1),TRUE)


in order things to work. And still use STRSAME
Thanks