Given a specifc folder path in a FM text field, I need to search the folder for any file with the extension ".log" and
1 Repalce any single quote in the file's contents with a double quote
2 Change the file's extension to ".csv"
Any guidance will be much appreciated!
I have to import these files as if they were csv files but FM does not like to do that when th extension is .log, and also it treats single quotes as a data character
The data does not contain any double quotes initally, otherwise I guess I could first subtstiute double double quotes for those.