This query will find call numbers with carriage returns and line feed characters in call numbers and remove them, using the Replace function:
Note: chr(10) is a line feed; chr(13) is a carriage return:
select
he.call_number,
replace (replace (he.call_number, chr(13), ''),chr(10),'') as fixed_call_number
from folio_reporting.holdings_ext as he
where he.call_number ~ '\n'
;
