oracle - BASH: Replacing special character groups -


i have rather tricky request...

we use special application connected oracle database. control reasons application uses special characters defined application , saved in long field of database.

my task query long field periodically , check changes. that, write content using bash script in file , compare old , new file md5sum.

when there's difference, want send old file via mail. problem is, old file contains these special characters , don't know how replace them example string describes them.

i tried replace them on basis of ascii code, didn't work. i've tried replace them appearance in file. (they this: ^p ) didn't work neither.

when viewing file text editor nano characters visible described above. when using cat on file, content displayed until first appearance of such control character.

as far know there know possibility replace them while querying database because of fact content in long field.

i hope can me.

thank in advance.

marco

you can use xxd change string hex representation, use xxd -r convert back.

or, can use uuencode , uudecode.


Comments

Popular posts from this blog

curl - PHP fsockopen help required -

HTTP/1.0 407 Proxy Authentication Required PHP -

c# - Resource not found error -