Can XSLT check specific type?

JohnKiller · February 16th, 2012, 07:06 PM

The input xml like:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<request>
  <address streetName="6th" streetType="Ave"/>
</request>

For the streetName, if it is number with -th, we need the ouput only has the number, but sometimes the streetName="Wath", if so the output should be the same as "Wath".

For this case, the output xml should be:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<response>
  <adr number="6" type="Ave"/>
</response>

The XSLT version is 1.0.

Thank you in advance.

samjudson · February 17th, 2012, 04:42 AM

XSLT 2.0 has various regular expression functions, such as matches().

Code:

<xsl:choose>
  <xsl:when test="matches(@streetName, '\d+(th|nd|rd)')">
  ...
  </xsl:when>
  <xsl:otherwise>
  ..
  </xsl:otherwise>
</xsl:choose>

In XSLT 1.0 you'd have to use substring and other string manipulation functions to do the work more manually.

JohnKiller · February 17th, 2012, 08:56 AM

Thank you, Sam. Would you give the 1.0 code? I do not know how to check the streetName starts with number and end with "th|rd|nd", 1.0 does not support ends-with function. Thank you.

samjudson · February 17th, 2012, 10:29 AM

You'd have to use substring() and string-length() to get the last two characters. Then if that equal "th", "rd" or "nd" then do the same to get the beginning of the string, and convert that to a number using the number() function.

JohnKiller · February 17th, 2012, 10:49 AM

Quote:

Originally Posted by samjudson

You'd have to use substring() and string-length() to get the last two characters. Then if that equal "th", "rd" or "nd" then do the same to get the beginning of the string, and convert that to a number using the number() function.

Thank you, Sam. Is there any way to check the part before last two characters is a number?

samjudson · February 17th, 2012, 11:47 AM

Yes, the boolean(number(string)) returns true if the string is a number, and false if it is not.

JohnKiller · February 17th, 2012, 12:17 PM

Yes, I tried and it works. Just one more issue is that: when

Code:

<xsl:when test="substring-after(address/@streetName,'(th|st|nd|rd|TH|ST|ND|RD)')='' and substring-before(address/@streetName,'(th|st|nd|rd|TH|ST|ND|RD)')!=''">
  <xsl:value-of select="substring-before(address/@streetName,'(th|st|nd|rd|TH|ST|ND|RD)')"/>
</xsl:when>

the (th|st|nd...) would not work, this is to check after "th" whether there is more character and before "th" whether there is character(there is one street called "th street"). why?

Thank you!

Quote:

Originally Posted by samjudson

Yes, the boolean(number(string)) returns true if the string is a number, and false if it is not.

samjudson · February 17th, 2012, 12:32 PM

XSLT 1.0 doesn't support regular expressions, so your code is trying to find the exact string "(th|st..." which doesn't exist.

You'd need to create two variables:

Code:

<xsl:variable name="suffix" select="substring(address/@streetName, string-length(address/@streetName)-2,2)"/>
<xsl:variable name="rest" select="substring(address/@streetName, 1, string-length(address/@streetName)-2)"/>

Then test them:

Code:

<xsl:when test="($suffix='th' or $suffix = 'rd' or $suffix='st' or $suffix='TH' or $suffix = 'RD' or $suffix='ST') and boolean(number($rest))">
...
</xsl:when>

JohnKiller · February 17th, 2012, 12:59 PM

I see. Thank you so much, Sam.

Quote:

Originally Posted by samjudson

XSLT 1.0 doesn't support regular expressions, so your code is trying to find the exact string "(th|st..." which doesn't exist.

You'd need to create two variables:

Code:

<xsl:variable name="suffix" select="substring(address/@streetName, string-length(address/@streetName)-2,2)"/>
<xsl:variable name="rest" select="substring(address/@streetName, 1, string-length(address/@streetName)-2)"/>

Then test them:

Code:

<xsl:when test="($suffix='th' or $suffix = 'rd' or $suffix='st' or $suffix='TH' or $suffix = 'RD' or $suffix='ST') and boolean(number($rest))">
...
</xsl:when>