Solved

@ProperCase in column

Posted on 2004-03-26
3
243 Views
Last Modified: 2013-12-18
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
Comment
Question by:adspmo
3 Comments
 
LVL 31

Accepted Solution

by:
qwaletee earned 125 total points
ID: 10687403
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
 
LVL 24

Assisted Solution

by:HemanthaKumar
HemanthaKumar earned 125 total points
ID: 10687410
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
 

Author Comment

by:adspmo
ID: 10687440
Duuudd

Have not finished the first tea yet, sorry to bug you guys with that
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question