Replace unknown character from csv data

Question

var csvUrl = "http://services.runescape.com/m=clan-hiscores/members_lite.ws?clanName=divine%2089";

var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();

var csvData = Utilities.parseCsv(csvContent);

datasheet.getRange(1, 6, csvData.length, csvData[0].length).setValues(csvData);

The above gets a list in csv format and it outputs fine into google sheets. The problem is that it replaces all spaces with an unknown character that I am not sure how to remove easily.

The character is: �

Is there an easy way to take the data before it gets outputted to the sheet and replace � with a regular space?

Answer 1

You can replace in the string like so:

var stringy = '��SOMETHING��'
var replacedStringy = stringy.replace(/�/g, ' ');  //replaces all encounters

for your script

function myFunction() {
  var csvUrl = "http://services.runescape.com/m=clan-hiscores/members_lite.ws?clanName=divine%2089";

  var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();

  var csvData = Utilities.parseCsv(csvContent);
  for(i in csvData){
    for(j in csvData[i]){
      csvData[i][j]=csvData[i][j].replace(/�/g, ' ');
    }
  }

  SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(1, 6, csvData.length, csvData[0].length).setValues(csvData);
}