Dropping delimiters

[lovely kasi]

Hi,
While using the sqoop import  if we want to drop the \n or \r characters we
use the option "hive-drop-import-delims" options.
But how can i drop '|' character also from the field values while importing.

Thanks,
Lovely