Crystal 11: Trim last 4 characters of a field? 1

[CrystalKim]

Hi all, I am sure there is a simple formuala for this but I can't figure it out (I looked in my Crystal book and have been googling for 1/2 hour.)

Anyhow, I have an account number that is stored as text. For security purposes I only want to show the last four digits.

Is there a text formula I can use to do this (like the trim function)?

Thanks as always.

 

[kskid]

How about right({table.field}))

 

[kskid]

Aaargh.... should be right({table.field},4)

 

[CrystalKim]

I KNEW it was going to be something that simple but coudln't figure it out for the life of me.

Thanks, it worked like a charm!!!