I have a column name in a content type named "Real Estate Location".
That column is of type "lookup".
I have modified <CommonViewFields> and ItemStyle.xsl to show the column.
A simple <xsl:value-of select=…> returns back an internal value that includes ordinal position data, such as:
1;#Miami
To get the human-friendly value, use xsl substring-after, as shown:
<xsl:value-of select="substring-after(@Real_x005F_x0020_Estate_x005F_x0020_Location,’#’)"></xsl:value-of>
Use this technique whenever you are working with lookup values in XSL transforms and need to get the human-friendly value.
<end/>
Hi Paul,
It looks like what you are describing here is the solution to what I need, but am unfortunately a newbie in XSL and can’t figure it out from your post above.
Let me quickly explain what I am trying to do and what I need and would greatly appreciate your help 🙂
I am creating product pages in a document library and in this library I am associating values through columns to each page, e.g. Page name: Product A and in that row a column "Market applicability". The values that are available for "market applicability" are in a custom list in a separate library and are imported via a look-up and then defined that various options are possible (in that column).
Now let’s say product A is available in the US & Canada and we select those in the column attributes to the page. I would like to have US & Canada then appear on the page itself and I think what you are discussing above is the answer to my question – now the big Q is exactly how do I implement it?
My company does not allow me to work with sharepoint designer and we do not have the DFWP web part available :s so I have been doing the majority of my alterations with code in CEWP (I also have a XML/XSL web part available if that helps).
The only solution that my web management team has given me is to create an alternative view of the product page document library for that product and include that view in my page – however given that we have over 200 products and I have this issue with 4 columns (market applicability, target audience, etc.) I do not want to spend my time creating 1,000 views.
My site structure is as follows:
Product A page: https://domain.com/sites/mysitename/productpages/ProductA.aspx
Product page document library: https://domain.com/sites/mysitename/productpages/Forms/AllItems.aspx
Original list with values: https://domain.com/sites/mysitename/Lists/Market%20applicability/AllItems.aspx
Could you please advise me what code I need to use in order to include the market applicability values of "US & Canada" (in this case) in my product page?
Thanks so much for your help!
Vivian