Can the ID from a referenced column be obtained when using SharePoint's Data View Part?

Question

I have a Data View Part pulling from a list that has a lookup column to another list (title linked by ID)

And somewhere in the XSLT of the data view web part configuration, it reads

<xsl:value-of select="@ColumnX"/>

Now since ColumnX is a reference to another list (linked to item), how do I go about obtaining the ID rather than the text? Is there a ddwrt trick out there?

Answer 1

The value of a Lookup Field is in the format of "ID;#Text". To get the ID value, we use is regular xslt:

<xsl:value-of select="substring-before(@ColumnX, ';#')" />

Answer 2

I have same problem, and return '' because not return with format ID;#Content, it return Content only. Please help me. Send my email [email protected]