Omitting Last few digits in string

[jbricks]

Hello there. I'm new knowing mainly basic Crystal Report writing. I am trying to omit the last 4 digits in a string. The string is data extracted from a database and has many different results, such as a name of a department. The srings are all different lengths, so using the "Left" subscript isn't helping me....Are there any other solutions?

Thank you.

 

[CoSpringsGuy]

left({databasefield},len({databasefield})-4)

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[jbricks]

Thank you very much...what does len stand for?

 

[CoSpringsGuy]

length



_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[jbricks]

That is what I thought, just thought I would check to make sure. Thank you for your help.