I am trying to convert some CSV files but the format of the files is making it difficult for me.
I have CSV files that use two different limiters, in the TYPE1 ";" is used. and in TYPE2 "|" is used. And the data inside is not formatted the same, so I'm interested in keeping it separate.
The code I have works fine for one of the two format types (in this case for TYPE1). Right now what it does is grab all the files from a folder and import them into a tab removing duplicate headers. I would be interested if it took all the TYPE1 files and unified them in one tab, and all the TYPE2 files in another tab.
File names begin with "TYPE1_xxxx" and "TYPE2_xxxx"
Thanks!
function onOpen(e) {
var ui = SpreadsheetApp.getUi();
ui.createMenu("