Filemaker: how to remove quotes from imported data?

Factual Questions
1

I created an FM database using data imported from an Excel spreadsheet. On the spreadsheet, there’s no indication of what it is about a given cell that causes this, but when the data is imported into FM, some of the records have data in a filed that is encliosed in quotes. I know what this means, it’s a literal text indicator, but I don’t want it. I want ALL the quotes to go away.

I have researched function references, script references, the FM Pro Bible…and nothing tells me how to REMOVE quotes, only how and why to INCLUDE them.

And I should add everything I’ve tried that involves telling Filemaker to “find” or otherwise isolate and identify the quotation marks, doesn’t work, even when I copy/paste the marks to make sure they are the right marks.

This seems like something that must have come up before now.

Any ideas?

2

…this might help, although the advice is a little bit old…

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=4468&p_created=1115172845

3

I have never heard of FileMaker. But, what about instead if importing directly from Excel, first export the Excel to an ASCII delimited .txt file. Then try to import the .txt file into FileMaker.

I would try different formats.