sparky1
-
Posts
2 -
Joined
-
Last visited
sparky1's Achievements
-
Removing the Last Character from a Field
sparky1 replied to sparky1's topic in Calculation Engine (Define Fields)
Thanks -Queue, Your formula works perfect You've saved the day. -
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.