R

Retrieves data within a range.

Syntax

Rn,m [ ; n,m ... ]

n specifies the lower limit of the range.

m specifies the upper limit of the range.

; separates multiple ranges.

Remarks

If the data does not meet the range specifications, an empty string is returned.

Examples

The following example shows the effect of the R (Range Check) conversion code with the Iconv function.

Conversion Expression

Internal Value

X = Iconv("123", "R100,200")

X = 123

The following example shows the effect of the R (Range Check) conversion code with the Oconv function.

Conversion Expression

External Value

X = Oconv(123, "R100,200")

X = 123

X = Oconv(223, "R100,200")

X = ""

X = Oconv(3.1E2, "R100,200;300,400")

X = 3.1E2