I created a joined subview in a data view web part however it is failing to find any matching items because one of my join columns IdeaID. is bringing in additional characters (see image below). Unfortunately I can't add another column to my list that contains only the IdeaID value because it will interfere with an SSIS ETL I have in place. I suspect I need to add some XSLT like
xsl:value-of select="format-number(substring-before(@IdeaID.,';#'),',##0;-,##0')"/>to trim the IdeaID but I can't seem to hit on the correct line of code in SharePoint Designer. Anyone know what XSLT needs to be modifed so that my IdeaID will render correctly and successfully find a match? Thanks in advance!