Substitute single quote '

[DikkeHenk]

Hi,

I am trying to create a Name Formatting function for Dutch names. Dutch names often have single quotes ' in it.

example:

Maarten 't Hart or Henk-Jan van d'r Vaart

Filemaker does not seem to recognize single quotes in calculations. (reserved character) Anyone knows how to substitute a single quote ' in a text.

Henk

[Genx]

Hi Henk,

The double-quote is a reserved character, the single quote isn't. Can you post the calculation you're having trouble with?

[DikkeHenk]

To be sure I tried it in a single auto-enter _Name textfield but NO substitute single quote yet.

This does not work

Substitute ( _Name ; "'" ; "00" )

This works

Substitute ( _Name ; "-" ; "11" )

I also tried with the position function to locate the single quote in the text but that does not seem to work either.

Information on the internet says that among other characters like, ( /* and // ) a single qoute is also used to add comments in Filemaker functions.

Henk

[fabriceN]

It works here, by just copypasting your formula. Both with smart quotes enabled or not.

Edited June 9, 2007 by Guest

[Genx]

Are you copying and pasting this name from somewhere else or importing it?

... Or are you directly entering into FileMaker?

[DikkeHenk]

Thank YOU guys,

Another problem solved. I have set the smart quote in the file options dialog 'off'. Now it is working as it should be.

I am now going to find out what those smart quotes are used for.

Thanks again