When you create csv files from the same systems than those which are not able to properly open them, you might need afterward to clean it up. I often find myself annoyed by so-called csv files that are actually delimited by semicolons, and commas are used as decimal separators. Here is a code to first replace commas by periods, then replace semicolons by commas.<\/p>\n\n\n\n
tell application \"Finder\" to set FileToEdit to selection as string\nset AccessToFile to open for access file FileToEdit with write permission\nset CSVContent to read file FileToEdit\nto switchText from t to r instead of s\nset d to text item delimiters\nset text item delimiters to s\nset t to t's text items\nset text item delimiters to r\ntell t to set t to item 1 & ({\"\"} & rest)\nset text item delimiters to d\nt\nend switchText\nswitchText from CSVContent to \".\" instead of \",\"\nset FirstStepText to result\nswitchText from FirstStepText to \",\" instead of \";\"\nset TextToWrite to result\nset eof of file FileToEdit to 0\nwrite TextToWrite to AccessToFile\nclose access AccessToFile<\/code><\/pre>\n\n\n\n