String manipulation

[CARLEENHOP]

Hi, I have a string eg. WK-WOVENS. I want it to appear on my report as WK-Wovens. If I change it to proper case it appears as Wk-Wovens, so i need to somehow tell it to leave everything before the '-' as uppercase and everything after as propercase. Does anyone know how? FYI - there are not always 2 characters prior to the '-' there can be only 1. Hence why I need the before/after '-' instead of saying after 2 characters.

Thanks
Carleen

 

[IanWaterman]

Try

if ubound(split({your.field},"-")) > 0 then
split({your.field},"-")[1]&"-"&propercase(split({your.field},"-")[2])
else {your.field}

Ian

 

[CARLEENHOP]

Thanks will give it a go and let you know

 

[CARLEENHOP]

Thanks, all good

 

[jannoth]

I didn't start this thread but am learning from other folks' problems etc. So purely for interest/learning, can someone please help my understanding?

I don't understand the need for this statement in IanWaterman's solution:

if ubound(split({your.field},"-")) > 0

Does it basically do the same thing as the following (which I seems simpler for me to understand)?

if {your.field} like "*-*"

Thanks - hope I'm not upsetting anyone by asking !

J

 

[lbass]

There are multiple ways of testing for the presence of a hyphen, so yes, you could use your approach. Whatever is easier for or makes most sense to you in this case. Sometimes one approach is better than another because of processing speed.

-LB