Delete the three right letters in a string 1

[bkrampe]

I was wondering if there was any code to delete the 3 right letters in a string automatically when it was inputed into a report?

 

[bdreed35]

Here is one way to do it:

mid({table.field},1,length({table.field})-3)

But that assumes that your field will always be more than 3 characters long. It is better practice to extend it a little bit to this:

if length({table.field}) > 3
then mid({table.field},1,length({table.field})-3)
else {table.field}

~Brian

 

[bkrampe]

Thanks it worked great.