Transform comma separated strings cell values to PostgresSQL arrays

GoogleAppsScripts.js

const SHEET_NAME = '+para_DB';
const TARGET_COLUMN_NAME = 'categoria';

const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName( SHEET_NAME );
const data = sheet.getDataRange().getValues();

let column = data[0].indexOf(TARGET_COLUMN_NAME);

// Transform comma separated strings cell values to PostgresSQL arrays
function transformDataToArray() {  
  
    for ( let i = 1; i < data.length; i++ ) {    

      if ( data[i][column] !== '' ) {
        
        let arr = data[i][column].split(',');
        arr = Array.isArray(arr) ? arr : [arr];
        arr = arr.map(s => s.trim());
        arr = JSON.stringify(arr);
        arr = arr.replace('[', '{').replace(']', '}');
        sheet.getRange( i+1, column+1 ).setValue(arr);
        
      }

    }
    
}