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.

Replacing non-breaking spaces with regular spaces

Pargas
in Finding & Searching

Featured Replies

  • Newbies

I wish to export the 4000 records in my FM Pro 6 database to xml format. I use non-breaking spaces in a title field for identification purposes. When the exported file is opened the text "Merck & Co." appears as "Merck

Have you tried using the Substitute Function in a calculation. It sounds like you only need this for an export. If so, create a calculation field and use the substitute function to replace the non-breaking space with a normal space. If you want this changed in the current field permanently, let us know and we can help you there too.

If you can't type a non-breaking space in the calculation box, you can capture one first. Create a field and calculation something like this:

YourExportField, Calculation, text result =

Substitute(YourCurrentField, "

  • Author
  • Newbies

Excellent!

It works; thank you very much.

Roger

Forgive my ignorance - pleeease! Wht is anon-breaking space and what is it used for?

Let's say you have are writing an article and there's a date like 22. April 2004. You don't want this to appear like:

"

Create an account or sign in to comment

https://fmforums.com/topic/23633-replacing-non-breaking-spaces-with-regular-spaces/
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.