remove word from column

[Eric Antunes]

Hi,

Complementing Patty answer, you should see what you are going to update before (I strongly recomend it) doing it:

select address_column, replace( address_column,'speed test',null) address_column_replaced
from table_name
where address_column != replace( address_column,'speed test',null);

And after above query results were verified, do the update:

update table_name
set address_column = replace( address_column,'speed test',null)
where address_column != replace( address_column,'speed test',null);

Best Regards,

Eric Antunes

[Eric Antunes]

Correction:

Complementing Patti's answer...

[Ratzie]

I am trying to get a script to work.
I have the list of tn's that I used when I appended that field but now I can not seem to get it to work.

#!/usr/bin/sh
cat test3|while read i
do echo $i
sqlplus -s admin/admin <update cust_table
set customer = replace (customer,'Speed Trail','');
where tn = ($i);
commit;
quit

EOF
done

[Patti Johnson]

What is the error that you are getting?
Also is tn a number? If not you will need to use quotes around '$i'.

You could use
update cust_table
set customer =
replace (customer,'Speed Trail','')
where customer like '%Speed Trail%'
/

( actually when I cut/pasted your sql I noticed the extra ; at the end of the replace)

You could use
update cust_table
set customer =
replace (customer,'Speed Trail',''); <<---
where customer like '%Speed Trail%'

[Ratzie]

Greatly appreciated!!
Thanks Patty