InStrRev Question

[ron]

InStrRev has the following syntax

InstrRev(stringcheck, stringmatch[, start[, compare]])

According to the Help section, "start" is "Optional. Numeric
expression that sets the starting position for each search. If
omitted, –1 is used, which means that the search begins at the last
character position. If start contains Null, an error occurs."

If I set "start" to -1, the expression evaluates correctly; if I set
start to any other value, the expression evaluates to zero. How can
you use "start" in InStrRev?...TIA, Ron

 

[Jim Cone]

The start number has to be equal to or greater than the "found" position.
Character numbering starts from the left, so the found position (for example)
of "c" in "revocation" is 5.
If you specify a start number less than 5 then the search will start to the
left of the c and the function will return 0.
--
Jim Cone
Portland, Oregon USA


"ron" <[email protected]>
wrote in message
InStrRev has the following syntax

InstrRev(stringcheck, stringmatch[, start[, compare]])
According to the Help section, "start" is "Optional. Numeric
expression that sets the starting position for each search. If
omitted, –1 is used, which means that the search begins at the last
character position. If start contains Null, an error occurs."
If I set "start" to -1, the expression evaluates correctly; if I set
start to any other value, the expression evaluates to zero. How can
you use "start" in InStrRev?...TIA, Ron

 

[ron]

The start number has to be equal to or greater than the "found" position.
Character numbering starts from the left, so the found position (for example)
of "c" in "revocation" is 5.
If you specify a start number less than 5 then the search will start to the
left of the c and the function will return 0.
--
Jim Cone
Portland, Oregon  USA

"ron" <[email protected]>
wrote in message
InStrRev has the following syntax

InstrRev(stringcheck, stringmatch[, start[, compare]])
According to the Help section, "start" is "Optional. Numeric
expression that sets the starting position for each search. If
omitted, –1 is used, which means that the search begins at the last
character position. If start contains Null, an error occurs."
If I set "start" to -1, the expression evaluates correctly; if I set
start to any other value, the expression evaluates to zero.  How can
you use "start" in InStrRev?...TIA, Ron

Jim...Thanks for the clear explanation and example, now I
understand...Best, Ron

 

[Nigel]

You could always set the start position as Len(stringcheck) for example

--

Regards,
Nigel
(e-mail address removed)

The start number has to be equal to or greater than the "found" position.
Character numbering starts from the left, so the found position (for
example)
of "c" in "revocation" is 5.
If you specify a start number less than 5 then the search will start to
the
left of the c and the function will return 0.
--
Jim Cone
Portland, Oregon USA

"ron" <[email protected]>
wrote in message
InStrRev has the following syntax

InstrRev(stringcheck, stringmatch[, start[, compare]])
According to the Help section, "start" is "Optional. Numeric
expression that sets the starting position for each search. If
omitted, –1 is used, which means that the search begins at the last
character position. If start contains Null, an error occurs."
If I set "start" to -1, the expression evaluates correctly; if I set
start to any other value, the expression evaluates to zero. How can
you use "start" in InStrRev?...TIA, Ron

Jim...Thanks for the clear explanation and example, now I
understand...Best, Ron

 

[Ron Rosenfeld]

You could always set the start position as Len(stringcheck) for example

Operationally, how does that differ from setting it to -1?

--ron