INSTRREV Question 2

[mrichey]

I'm trying to get the character position of the very last character in a string of data. I'm using INSTRREV looking for a "period" as shown below:
instrrev ({@updateaction_alias},".")

My problem is, the field doesn't always end in a period. Is there any way of looking for "any" character, no matter what it may be? A wild card type reference or something?

Thanks much for any help!!

 

[mbarron]

What about len({your.field})?

If this doesn't solve your problem, please post some sample data and expected results.


Mike

 

[Turkbear]

Try:

{@updateaction_alias}[Length({@updateaction_alias})]

Should return the last character ( based on the length of the string)

 

[Turkbear]

Hi,
Mike is correct, if you only want the position of the last character in the string -
I misread you as wanting to know what the last character was..