Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Removing the Last Character from a Field

sparky1
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

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.

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

  • Author
  • Newbies

Thanks -Queue,

Your formula works perfect !!!

You've saved the day.

Create an account or sign in to comment

https://fmforums.com/topic/24578-removing-the-last-character-from-a-field/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.