Removing the Last Character from a Field

[sparky1]

I need to strip/remove the last comma from thousands of records in our database. We need to leave the middle comma in place and we only need to remove the last comma:

As an example the existing records read like this:

ENGINE HARNESS, with gauges,

FORWARD LAMP HARNESS, with gauges,

The new records need to read like this:

ENGINE HARNESS, with gauges

FORWARD LAMP HARNESS, with gauges

I've tried creating a new calculation field and utilizing some of the different functions (right, replace, substitute etc.), but just can't seem to solve this one. Seems simple, but this one has me stumped. Any suggestions?

Thanks.

[-Queue-]

Case( Right( yourfield, 1 ) = ",", Left( yourfield, Length(yourfield) - 1 ) )

[sparky1]

Thanks -Queue,

Your formula works perfect

You've saved the day.

[Ugo DI LUCA]

What ?

No boolean in this calc JayTee ?!

[-Queue-]

LOL Nah, not this one.