Hi @leepoo, CSVBuddy might be a good tool to use. It’s free for personal and commercial use, and can be run as an executable or as an Auto Hot Key script, which means it could easily be incorporated in your workflow.
Changing field delimiters is really easy with this tool. Here’s a screenshot:
Make sure you get the latest version - update if necessary. I recommend compiling the source or running the script from the CSVBuddy github repo.
Update: Also included here are CSVBuddy-master.zip, a replacement CSVBuddy.ahk to account for a missing lib, and the missing lib (ObjCSV.ahk). If you run CSVBuddy from the extracted folder as-is, you’ll get an error message about the missing lib ObjCSV.ahk. The edited CSVBuddy.ahk requires ObjCSV.ahk to be in the same folder as CSVBuddy.ahk. The executable downloaded from the link at the top doesn’t have this issue.
CSVBuddy-master.zip (1.4 MB)
CSVBuddy_update.zip (36.5 KB)