Solved

@ProperCase in column

Posted on 2004-03-26
3
244 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

734 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