Onlydarksets

I’d love to create a filtered list from a calculated field, but I’m hitting a problem where it is prepending “string;#” to every stored value.  This is similar to this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2427800&SiteID=1

Of course, try searching for “string;#” in any search engine.  They all strip off the semi-colon and hash symbol, leaving the search pretty worthless.

The code snippet is:

<SharePoint:DVDropDownList runat=”server” id=”ff1{$Pos}” DataSourceID=”fdsConsultants2DS” DataTextField=”ConsultantName” DataValueField=”ConsultantName” selectedvalue=”{@Title}” __designer:bind=”{ddwrt:DataBind(‘i’,concat(‘ff1′,$Pos),’SelectedValue’,'SelectedIndexChanged’,'ID’,ddwrt:EscapeDelims(string(@ID)),’@Title’)}” /></td>

Where DataValueField is the calculated field in the lookup table (and SelectedValue tells it to store DataValueField).