Dropping the last character if it is something I don't need?

[silverseed71]

I have a string that is exactly 6 characters long but I want to cut off the last character if it ends with a "."

for example:

231.13
209.43
671.22
265.6. <---------If there is a period at the end I would like to cut the 6 character field down to 5 characters.

Any help would be greatly appreciated.

 

[BettyJ]

@remove
WhilePrintingRecords;
if right({yourstring},1)="." then
left({yourstring},5)
else {yourstring};