SharePoint - get value of calculated field without manual parsing

sharepoint sharepoint-2007
Chloraphil picture Chloraphil · May 22, 2009 · Viewed 19.1k times · Source

I have a calculated field in a list with this formula:
=CID & " - " & Title

When viewing the list, it might display as: "2 - Big Meeting". When I grab the value from code like so:
myItem["CIDandTitle"]

the value comes back as: "string;#2 - BigMeeting". Is there a "correct" way in sharepoint to extract the value or should i simply split on the semicolon and pound sign?

I am using MOSS2007.

Answer

Nathan DeWitt picture Nathan DeWitt · May 22, 2009

You have to cast it to an SPCalculatedField:

SPFieldCalculated cf = (SPFieldCalculated)myItem.Fields["CIDandTitle"];
string value = cf.GetFieldValueForEdit(myItem["CIDandTitle"]);

or 

string value = cf.GetFieldValueAsText(myItem["CIDandTitle"]);

Related questions

How do I use the Sharepoint Web Service to get a list of documents from .NET?

Technologies: Winforms, .NET, C#, Sharepoint Web Services I'm currently writing a winform desktop application that is supposed to access a specific list of Sharepoint documents and custom input variables (From a Sharepoint Document Library) http://www.infoq.com/articles/swanson-moss-web-services …

Read More
Sharepoint LookUp field on Choice field?

How to create a lookup field for the Choice field..For eg: In a list i have Choice field and i have to create an lookup column in other list pointing to this choice field ..When i select this list …

Read More
Can I create a COUNTIF calculated column in SharePoint?

Is there a way to create a SharePoint calculated column that returns a count of the number of entries in a list? So If I have 3 customers in my list with the company "Starbucks" I'd like the field to return "3"

Read More