Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

@ProperCase in column

Hi Guys

Does ProperCase not work in column formulas?

I have tried with the following and failed

A := @If(@Subset(@Length(HistoryNotes);1)>26; HistoryNotes; "");
@ProperCase(A);
"[<span title=\'" + A + "\'>]" + @Left(HistoryNotes;26) + "[<span>]"
and other variations

Is there another way?
0
adspmo
Asked:
adspmo
2 Solutions
 
qwaleteeCommented:
No, it works.  Your code is bad.  That @ProperCase isn't an assignment.

A := @If(@Subset(@Length(HistoryNotes);1)>26; HistoryNotes; "");
A_proper := @ProperCase(A);
"[<span title=\'" + A_proper + "\'>]" + @Left(HistoryNotes;26) + "[<span>]"
0
 
HemanthaKumarCommented:
It will work but your output doesnot include it so change the formula to this

A := @If(@Subset(@Length(HistoryNotes);1)>26; HistoryNotes; "");
B := @ProperCase(A);
"[<span title=\'" + B + "\'>]" + @Left(HistoryNotes;26) + "[<span>]"

~Hemanth
0
 
adspmoAuthor Commented:
Duuudd

Have not finished the first tea yet, sorry to bug you guys with that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now