Replacing non-breaking spaces with regular spaces

[Pargas]

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

[Lee Smith]

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, "

[Pargas]

Excellent!

It works; thank you very much.

Roger

[Oldfogey]

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

[dbruggmann]

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:

"