Problem formatting field

[cmcgann]

Hello All<br><br>I am running a report that queries a text field. the Text field looks like this : 0000000002000 Is there any way i can run a report that will remove the last 3 zero's <br><br>I tried the right(,3) function but to no Avail. <br><br>Thanks for your help&nbsp;&nbsp;<br>

 

[stem]

The function you used will return the 3 zero's to the right.<br><br>I would use:<br>Left({table.Field},(length({Table.Field} - 3)))<br><br>That would take care of variable length values in the field as well.

 

[LindaC]

Take a look at Mid (str, start), Mid (str, start, length)<br>in the Crystal help files.&nbsp;&nbsp;That should do the trick. <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>