During development of ParentText Mexico, it was found that carriage return characters (\r) were appearing in output text intended for translators. This phenomenon does not happen when the input spreadsheets are CSV files - maybe because Python automatically converts newline character sequences to \n.
This means it is the GoogleSheetReader, which uses the Google Sheets API, that is allowing carriage returns to be read in and affect downstream processing.
During development of ParentText Mexico, it was found that carriage return characters (\r) were appearing in output text intended for translators. This phenomenon does not happen when the input spreadsheets are CSV files - maybe because Python automatically converts newline character sequences to \n.
This means it is the GoogleSheetReader, which uses the Google Sheets API, that is allowing carriage returns to be read in and affect downstream processing.