Solved

@ProperCase in column

Posted on 2004-03-26
3
245 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

Technology Partners: 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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise 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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

717 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