Interstage Shunsaku Data Manager Application Development Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

B.3.6 Numeric Values

This method searches for documents by extracting the numeric component from the value of the element node, the value of text node, or the value of attribute node, and finding documents where this value matches the specified numeric value or documents where the specified size relationship holds. The numeric component is automatically extracted from the value of the element node, the value of text node, or the value of attribute node, and so this method can be used to search for numeric values that have been written in various ways.

The following figure shows the definition for numeric values.

[Figure B-16 Number Definition]

Numbers

For numbers, specify a digit between 0 and 9 inclusive.

Numeric Comparisons

Numeric comparisons extract the numeric component from the value of the element node specified by the path expression, the value of the text node specified by the text expression, or the value of the attribute node specified by the attribute expression, and compare this value to the numeric specified in the keyword.

• The first comparisons extract the numeric component from the value of the element node specified by the path expression, the value of the text node specified by the text expression, or the value of the attribute node specified by the attribute expression that fits the format above is treat as a numeric value.
• Any commas that appear in the integer part are ignored. If a decimal point has been specified, the decimal part is regarded as being everything up until the first non-numeric character after the decimal point.

Example

/doc/money = 1000

Evaluates to TRUE if the numeric component extracted from the value of the element node represented by 'doc/money' matches 1000.

In the following example, the value of the element node specified by the path expression contains multiple numeric values. In such cases, only the first numeric value is extracted.

Document A

<money>ABC123,456@789</money>

123456 is extracted.

Document B

<money>123456 7890123</money>

123456 is extracted.

Document C

<money>1,500 yen</money>

1500 is extracted.

• If the search data does not contain a valid numeric value string, the conditions will evaluate to FALSE.

  The following target search string does not contain a valid numeric value string.

  <money></money>

  
  

• Path operator '//' cannot be entered at the end of a path expression when performing numeric comparisons.
• Path element '*' cannot be entered at the end of a path expression when performing numeric comparisons.
• The '*' cannot be specified at the attribute name specified by the attribute expression when performing numeric comparisons.
• The number of digits in the numeric value specified as the keyword does not need to match that of the value of the element node specified with the path expression.

  Keyword

  /root/money > 1000

  
  

  In the following example, the element node specified with the path expression will be regarded as matching the search conditions.

  <money>1000.5</money>

   

• There is no need to make the number if digits in the integer part or decimal part of the values of element nodes, the value of text nodes or the value of attribute nodes consistent between multiple XML documents.

  Document A

  <money>1000.1</money>

  Document B

  <money>2000.05</money>

  Document C

  <money>10.5</money>