Why am I obtaining a "string;" text before the value of a SharePoint List field when I retrieve it?

Question

I am pretty new in**.NET** and moreover in SharePoint and I have the following problem working on a SharePoint 2013 project.

Into my code I do:

for (int i = 0; i < eitchettaCorrenteList.Items.Count; i++)
{
    string valoreColonnaIniziativaInternalName = eitchettaCorrenteList.Fields[nomeColonna].InternalName;

    string valore = eitchettaCorrenteList.Items[i][valoreColonnaIniziativaInternalName].ToString();
}

I am iterating on a SharePoint list named etichettaCorrentList and, for each row, retrieving the value of a specific field.

It works bu the problem is that this line:

string valore = eitchettaCorrenteList.Items[i][valoreColonnaIniziativaInternalName].ToString();

returns a strange value that contains the expected value (the one contained in my list) preceded by a code that is not part of the value of the selected field, something like: string;#S01-INIZIATIVA EUROPA 1 TEST

What is this string;? Why am I retrieving it? How can I correctly remove or not obtain this string; before the desired information? What is wrong? What am I missing?

which data type is eitchettaCorrenteList.Items[i][valoreColonnaIniziativaInternalName]? Maybe ToString function return metadata info too — Joe Taras
Don't use ToString(). There are many different field types, including lookups (which store both ID and text), pictures, multi-value text fields and lookupts etc. The way you wrote the code you are retrieving the internal data. — Panagiotis Kanavos
Can you say what type of field with that value ? You can see it in SharePoint list in list settings. Each field type can be cast to specific for SharePoint .NET classes. This classes has own methods to get value correctly. And may be if you will use this correct class to get value then your issue will be resolved. — user10745346
It is a calculated value that simply concatenate 2 text fields. What method have I to use? — AndreaNobili
String strPrice = priceField.GetFieldValueAsText(item["Retail_x0020_Price"]) Source: docs.microsoft.com/en-us/previous-versions/office/developer/… — Cleptus

Unknown Unknown · Accepted Answer · 2018-12-12T16:47:49

Use this link.

Here exists answer to your question. Your field type is SPFieldCalculated. Use such code:

var item = eitchettaCorrenteList.Items[i];
var field = eitchettaCorrenteList.Fields[nomeColonna];
string valoreColonnaIniziativaInternalName = field.InternalName;
if (field.Type.Equals(SPFieldType.Calculated)) {
}
    SPFieldCalculated cf = (SPFieldCalculated)field;
    string valore = cf.GetFieldValueForEdit(item[valoreColonnaIniziativaInternalName ]);
    // or 
    // string valore = cf.GetFieldValueAsText(item[valoreColonnaIniziativaInternalName ]);
}
else {
    string valore = item[valoreColonnaIniziativaInternalName].ToString();
}

Or may be this will work correctly with all cases:

var item = eitchettaCorrenteList.Items[i];
var field = eitchettaCorrenteList.Fields[nomeColonna];
var value = field.GetFieldValueAsText(item[field.InternalName]);

Why am I obtaining a "string;" text before the value of a SharePoint List field when I retrieve it?

1 Answers