Home > Software engineering >  CSV to Google Sheet with different limiters
CSV to Google Sheet with different limiters

Time:08-04

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("           
  • Related