If you are comfortable using a little bit of shell scripting:
When it comes to the task of replacing the single quote chars in a target file, one avenue that you might consider would be the use of the command line utility: tr
The tr utility will allow you to perform a simple character replacement in a file, and output the result to another file.
This will not help you with the task of scanning the directory and identifying which files you wish to process, but it will help with the actual processing of each file, i.e. with the task of replacing single quote chars with double quote chars.
As an example, a simplified AppleScript which operates on a single file might look like this:
set varPath to "/Users/MyOSXUserName/Desktop"
processFileSwapQuotes(varPath, varPath, "MyTargetFile")
on processFileSwapQuotes(varInputFolder, varOutputFolder, varFileNameSansExtension)
set varTargetPath to varInputFolder & "/" & varFileNameSansExtension & ".log"
set varOutputPath to varOutputFolder & "/" & varFileNameSansExtension & ".csv"
set varShellScript to "cat " & varTargetPath & " | tr \\' \\\" > " & varOutputPath
do shell script varShellScript
You could do it with PHP in a web browser....
(I would get stuck where you are with the AppleScript I think)
Sent from my iPad
11th Hour Group Pty Ltd