Question

Please write a query to remove carriage returns and non-printable characters from a column. see data in table 74 and the expected output in table 75. drop table tt7; create table tt7 (c1 varchar(20)); insert into tt7 values ('St. Louis' || chr(9) || 'MO' || chr(9)); insert into tt7 values('A' || chr(10) || 'B'); select * from tt7; Table 74: 2 records c1 St. Louis MO A B Table 74: 2 records c1 cc St. Louis MO St Louis MO A B B

          Please write a query to remove carriage returns and non-printable characters from a
column. see data in table 74 and the expected output in table 75.
drop table tt7;
create table tt7 (c1 varchar(20));
insert into tt7 values ('St. Louis' || chr(9) || 'MO' ||
chr(9));
insert into tt7 values('A' || chr(10) || 'B');
select * from tt7;
Table 74: 2 records
c1
St. Louis MO
A
B
Table 74: 2 records
c1
cc
St. Louis MO St Louis MO
A
B
B

Please write a query to remove carriage returns and non-printable characters from a
column. see data in table 74 and the expected output in table 75.
drop table tt7;
create table tt7 (c1 varchar(20));
insert into tt7 values ('St. Louis' || chr(9) || 'MO' ||
chr(9));
insert into tt7 values('A' || chr(10) || 'B');
select * from tt7;
Table 74: 2 records
c1
St. Louis MO
A
B
Table 74: 2 records
c1
cc
St. Louis MO St Louis MO
A
B
B

Added by Margarita H.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Samuel Goyette

Step 1

We can use the `regexp_replace` function to replace any non-printable characters with an empty string. Next, we need to remove the carriage returns. We can use the `replace` function to replace any carriage returns (`\r`) with an empty string. Finally, we need Show more…

Show all steps

Thanks for your feedback!

PostgreSQL Question: Write a query to remove carriage returns and non-printable characters from a column. The original data is in table 74, and the expected output is in table 75. Please write a query to remove carriage returns and non-printable characters from a column. See the data in table 74 and the expected output in table 75. DROP TABLE IF EXISTS tt7; CREATE TABLE tt7 (c1 varchar(20)); INSERT INTO tt7 VALUES ('St. Louis Il' || chr(9) || 'Mo' || chr(9)); SELECT * FROM tt7; Table 74: 2 records c1 St. Louis MO A B Table 75: 2 records c1 CC St. Louis MO St Louis MO A B B