AnsweredAssumed Answered

FIND A QUOTE MARK

Question asked by MikeDunglinson on May 31, 2010
Latest reply on Nov 20, 2011 by bookalaka_1

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

 

Outcomes