title: How to remove unwanted character from string in Google sheet
body: <p>I am trying to do a bit of cleaning up on some data that I have imported from a csv file. I figured out how to get the formatting for some of the columns how I need it but am struggling with the double quotes that remain on either end of each row. I assume the quotes are being added as a result of the <code>getDataAsString()</code> function.</p>
  
  <p>As you can see from the below I am trying to use <code>replace()</code> to get rid of the double quote from the values in the last column. The logger shows the data without the <code>"</code>, but the line I have used is not having any effect on the data in the sheet. I suspect this is because all I am doing with the script that I have so far, is saying "show me the value from the last column without the quote" but not actually updating the data. </p>
  
  <p>How can I convert the "show" line to an actual change data line?</p>
  
  <pre class="lang-js prettyprint-override"><code>function importFromCSV() {
    var file = DriveApp.getFileById(listLatestFile());
    //var csvFile = file.getBlob().getDataAsString();// get string content
    var csvFile = file.getAs('text/plain').getDataAsString();
    //Logger.log(csvFile);// check in the logger
    var csvData = CSVToArray_(csvFile);// convert to 2D array
        var ss = SpreadsheetApp.getActiveSpreadsheet();
        var sheet = ss.getSheetByName("ImpCSVData");
        sheet.clear();
        sheet.getRange(1,1, csvData.length, csvData[0].length).setValues(csvData);// write to sheet in one single step
        var test = sheet.getRange(1,csvData[0].length, csvData.length, 1).getValue().replace("\"","");
        Logger.log(test);
        sheet.getRange(1,4, csvData.length, 2).setNumberFormat("DD/MM/YYYY");
        sheet.getRange(1,6, csvData.length, 1).setNumberFormat("@STRING@");
        sheet.getRange(1,csvData[0].length, csvData.length, 1).getValue().replace("\"","");
    }
  </code></pre>