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.

calc field that substitutes tabs for spaces.

Featured Replies

I use calculation fields and the substitute function for harmonizing the appearance of certain text fields like addresses, for example for changing

  • Author

WEll I'm answering my own question but I simply copied the ASCII tab character within Character Assassin and copied that into my formula. There is perhaps a more orthodox way of doing it and if so I would still like to know.

Nope that is the only way to capture a Tab. (i.e. from a tab used in a document).

Lee

I use calculation fields and the substitute function for harmonizing the appearance of certain text fields like addresses, for example for changing ?St.? or ?St? or ?ST? always into ?street?. I would like to add to the cald a substitute of any tabulation (ASCII 9) into a simple space but I don't know and can't find how filemaker recognizes an ASCII character in a formular. Anyone have any ideas ?

Put a tab in a global and use the global in the calc

Create an account or sign in to comment

Important Information

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

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.