Embedded tabs in data

[Gail RIley]

I have a number of rows in multiple Oracle tables that have tabs embedded in a data field. This is causing problems with a conversion program an application is trying to run. Does anyone have any suggestions for removing the tabs?

 

[Marco Kalter]

How about this?

update your_table
set some_column = replace(some_column, chr(9), ' ')
where some_column like '%' || chr(9) || '%'

This will replace all tabs with spaces.

 

[Gail RIley]

Perfect. Thank you so much!