6 Replies Latest reply on Nov 20, 2011 6:05 PM by bookalaka_1

    FIND A QUOTE MARK

    MikeDunglinson

      Title

      FIND A QUOTE MARK

      Post

      I have a stock file which I export from filemaker as a csv file. I then import the file into a DOS application

      Some users may enter (") quote marks in the stock lines for example 24" (24 inches). This plays havoc

      with my csv import as the quote mark is seen as an end of line and the import lines become disjointed.

       

      Can anyone tell me how to find a quote mark embedded in a text string in a Filemaker field.

      I have tried searching for " but this does not work

       

      I could then write a small script to search for and remove the quote marks in my stock file before

      exporting it to the csv file

       

      FM10 Windows 7 network

       

      Many Thanks

       

      Mike