Format string - capitalize format

chrisp

Hi,

I'm working with BIRT RCP Designer version 2.2.1 and I'm encountering a problem with the format string function. I want to capitalize a string (which is in uppercase), however, the only options from the drop down list within the property editor - data>properties>format string are "unformatted", "uppercase", "lowercase" and "custom". To get around the issue, I then used the text transform function (property editor- data>properties>advanced) to capitalize the string. This works when I selected the capitalize option in "text transform" and the lowercase option in "format string". Is this the only option to capitalize a string?

There is another problem in that the entire string is in lowercase when exported to Excel.

Any help on this matter is appreciated.

mwilliams

Hi chrisp,

I don't have a copy of 2.2.1, but I tried what you said in 2.2.2 and it doesn't work as you described it does in 2.2.1. I tried manually formatting the string using a computed column of type string with an expression like:

row["OrigString"].substring(0,1).toUpperCase() + row["OrigString"].substring(1,row["OrigString"].length).toLowerCase();

This value seemed to work perfectly for all outputs.