RemoveSmartQuotes (text)

Version 2


    Custom Function


    Mac OS X, Windows
    Andrew Duncan
    FMP 10, 11
    Web: Yes
    File Type: None
    Server: Yes
    FileSize: 0 kilobytes



    FileMaker Pro has the option per file to use smart quotes which are represented as the curly quotation marks and curly apostrophes which is set via the File menu > File Options>Text tab. These smart quotes can cause problems when interfacing with external systems that don't support smart quotes.


    This functions uses the new Char function in FileMaker Pro v10 to remove any single or double smart/curly quotes from the specified text and replace them with plain (straight) quotes and apostrophes. (You can make this function work with previous version of FileMaker by copy/pasting an example of each left/right single and double smart quote/apostrophe into the calculation in place of the Char function).




    // SYNTAX: RemoveSmartQuotes (text)

    // ORIGIN:

    // NOTES: Removes Smart/Curly Quotes and Apostrophes from specified text into non smart/curly quotes and apostrophes. Requires FileMaker 10 or higher

    // VERSION: 1.0v1

    // © 2010 Andrew Duncan, Databuzz,Sydney, Australia



    Substitute (


    text ;


    [ Char ( 8216 ) ; "'" ] ; // left smart quote

    [ Char ( 8217 ) ; "'" ] ; // right smart quote


    [ Char ( 8220) ; "\"" ] ; // left double smart quote

    [ Char ( 8221) ; "\"" ] // right double smart quote




    Sample Input

    Sample Output
    “hello World”

    "hello World"

    Developer's Notes



    FileMaker Inc. provides this content on an “As Is” basis, without any warranty, and subject to the terms of the FileMaker Technical Network Agreement. FileMaker makes no representations and is not liable for any content or related information. You may use the content as part of your own solutions and for your customers, but you may not otherwise publicly distribute any content that you did not submit. ©2009-2011 FileMaker, Inc. All Rights Reserved. FileMaker is a trademark of FileMaker, Inc. registered in the U.S. and other countries.