fsgetcsv无法解析字段中带单引号的文件

I'm having issues using fsgetcsv to import a text file into a database, the issues stems from some of the fields containing names with a single quote char in the names (irish database), fields are escaped by the ^ character and that bit is working fine but it basically tells me I have an error in my SQL syntax when it reaches a field with the ' character.I'm having issues using fsgetcsv to import a te