Hi,

Can you not add a update statement at the end of the package, which update all that column and removes any pipeline characters?

update yourtablename

set yourcolumnname = REPLACE(<columnname>,char(124),char(32))