A substitute question

mikedigitize · Post by **mikedigitize** » February 6th, 2012, 6:59 am

Is there a way to substitute an interval f.ex:
Substitute="1,2,3":"Blue","0":"Red" or
Substitute="1","2","3":"Blue","0":"Red"

/Mike

Post by **Brian** » February 6th, 2012, 7:09 am

You could use RegExpSubstitute.

Like this:

RegExpSubstitute=1
Substitute="[1-3]":"Blue","0":"Red"

or without regular expressions, like this:

Substitute="3":"Blue","2":"Blue","1":"Blue","0":"Red"

-Brian

mikedigitize · Post by **mikedigitize** » February 6th, 2012, 7:14 am

Great, thanks Brian! How aboute < , > = ?

Post by **Brian** » February 6th, 2012, 7:27 am

Substitute=">":"?","<":"?"

I assume you meant change greater than and less than to a question mark.

Here is some more information on Substitute.

-Brian

mikedigitize · Post by **mikedigitize** » February 6th, 2012, 7:48 am

Yes.. sorry.
I greatful for your help,
/Mike