| Author |
Message |
belfane
Newbie
Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
|
   Topic: if small caps then crred
Posted: 03 Mar 2016 at 5:07am |
|
Hello,
I'm wondering if someone would be able to help with a formula for a font color change based on the data containing small caps.
Something like this:
if {this.table} = lowercaps then crred
else if {this.table} = uppercase then crblack
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 03 Mar 2016 at 7:32am |
|
there are probably better ways but here is one
if instr(lowercase({this.table}),{this.table},0)= 1 then crred else crblack
|
|
IP Logged |
|
belfane
Newbie
Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
|
Posted: 03 Mar 2016 at 9:42am |
This worked flawlessly! Thank you very much! 
|
|
IP Logged |
|
belfane
Newbie
Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
|
Posted: 03 Mar 2016 at 11:04am |
|
Any chance you would part with a little more of your CR knowledge? The formula does work very well with all lower case. However, when there is a dash in-between, all of the data on every line turns red. Any ideas?
Works well for lower case: 2fh34r
Does not work for lower case: 2f-h34r
Thanks again!
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 04 Mar 2016 at 2:34am |
|
Some basic tests using your sample string (2f-h34r) are not causing issues for me.
You can try and use a replace to remove the dash
instr(lowercase(replace('{this.table},"-","")),replace({this.table},"-",""),0)= 1
|
|
IP Logged |
|
belfane
Newbie
Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
|
Posted: 04 Mar 2016 at 3:31am |
|
I tried your edited version, but received the following error:
The matching ' for this string is missing.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 04 Mar 2016 at 3:40am |
|
had an extra ' in it after the first replace. Just remove it
instr(lowercase(replace({this.table},"-","")),replace({this.table},"-",""),0)= 1
|
|
IP Logged |
|
belfane
Newbie
Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
|
Posted: 04 Mar 2016 at 3:45am |
|
Thank you for your reply. I did try that, but was given another error:
"A number, or currency amount is required here."
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 04 Mar 2016 at 3:49am |
|
you replaced {this.table} with your field and it is a string, correct?
What did it highlight when you got the error?
|
|
IP Logged |
|
belfane
Newbie
Joined: 18 Apr 2013
Online Status: Offline
Posts: 21
|
Posted: 04 Mar 2016 at 3:54am |
|
Yes. That's the odd part, nothing is highlighted as you would suspect. It simply moves the cursor back to the beginning. In front of:
// This conditional formatting formula must return one of the following Color Constants:
As before, I'm adding the formula to the font color.
|
|
IP Logged |
|
|
|
