I am trying to extract just a portion of data from an XML data source:
<Row>
<Col Name="Col0">123456<CellColour>36</CellColour>
<FontColour>1</FontColour>
<Bottom>1</Bottom>
<Bold>False</Bold>
<Italic>False</Italic>
<TextDirection>0</TextDirection>
</Col>
</Row>
When I extract the Col field I get "1234563612111FalsexlCenterxlBottomFalse00Fals e" using " <xsl:value-of select="Col"/>".
I just want the first portion of data "123456". I do not need any of the html tags or html data.
Any suggestions? Any direction on this would be greatly appreciated.
Thanks.