Capital letters after .

[vikasshana]

Hi,

I’ve data like below in my app

A.b
C&d

So now requirement is I want string to be capital after . and &. I would like to see output as below. I want a function in calculated dimension in chart.

A.B
C&D

Regards,
Bharath Vikas

[tresesco]

Is there any part of the string that is not required to be in capital? Can you give some more examples to clarify that?

[kishorj1982]

Capitalize should work here.

Capitalize(Column name)

[vikasshana]

Here it is @tresesco

Input:
A.bulk
C&dare

Output:
A.Bulk
C&Dare

[vikasshana]

Can some one help me on this request please.


@stalwar

[tresesco]

Try:

=Left(Field,FindOneOf(Field, '.&'))&Capitalize( Mid(Field,FindOneOf(Field, '.&')+1))