Hide last 5 characters of a string

[jcg6]

I would like to hide the last 5 characters of a field in a report. I have been playing with the LEN, MID, RIGHT, LEFT funtions, but can't come up with the right combination.

Does anyone have an example of how I would do this?

Ex: 123456789 would print 1234 and leave off the 56789

Any guidance would be most appreciated. Thanks.

 

[hneal98]

is the field always the same length?

 

[hneal98]

You could do this:

=left$(StringName,len(StringName) - (len(StringName)-5))

 

[MakeItSo]

Just a "Len" too many, hneal:
=left(StringName,len(StringName) - 5)
;-)

 

[jcg6]

THANK YOU ALL!!! That is exactly what I needed to know!!

 

[hneal98]

Sorry, that extra len would be if you wanted to see the last characters.

 

[MakeItSo]

Ah! Yeah, right.

P.S: I always used Left and Right functions for all sorts of string manipulations until I learned to esteem the simplicity of the mid function in these fora:
e.g. Mid(string,len(string)-5) will perform the exact same thing, i.e. return only the last 5 characters.

Was it xlbo or dyarwood I learned this from? I don't remember... ;-)

 

[hneal98]

good reasoning.