Cleaning a text field of superfluous characters

[Johnny777]

Hi 

I need to clean up a large text field in an FM database.  This is prior to transferring it to an SQL database

Basically I need to get it like a .txt file.  At the moment it has all kinds of rubbish in as these text fields were populated by crawling large websites - so all kinds of funny symbols in there and mysql won't have anything except clean text

The limit of my thinking is to run a script which only leaves the basic keyboard characters - there can be no tabs as the export is to a tab delimited file

Please bear in mind I only have access fm 10 pro and fm 9 pro adv

Many thanks

[comment]

all kinds of rubbish

 

is not a good definition of a problem. Perhaps something like this can help, though:

http://www.briandunning.com/cf/1291

 

 

there can be no tabs as the export is to a tab delimited file

 

That's not really an issue, because Filemaker will convert in-field tab characters to spaces when exporting to a tab-delimited file.