Pulling only last # in a field

[jr1vas]

Hello,

Does anyone know how to pull only the last # within a field?

For example:

ID: 12345
ID: 123
ID: 12345678

I would like to tell the report, if the last # in this field is 5 then "....", if the last # is 8, then "...."..

Thank you for any suggestions

 

[Reebo99]

Assuming this is a number field :

Right(ToText({Table.ID},0,"&quot,1)

If it's a string :

Right({Table.ID},1)

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)

 

[synapsevampire]

Try:

Switch(
Right(ToText(123456,0,"&quot,1) = "1", "Some text for 1",
Right(ToText(123456,0,"&quot,1) = "2", "Some text for 2",
true, "Wasn't any of the above"
)

-k

 

[jr1vas]

Thank you, let me give this a try.

 

[jr1vas]

Hi Reebo,

I tried Right({Table.ID},1)

and it worked!!! Thanks a bunch.