Remove some special ascii character

Shell Programming and Scripting
1

Hello

I have this special caracter after retreving rows from sql server:

"....spasses: � Entrem al valort 6050108002811 � El donem..."

I would like a sed command to remove it..or just know it's ascii code in order to replace it into my sql sentence.. Hope some one knows how to do that.

Thanks a lot in advance !

Cheers

2

Try:

perl -pe 's/[^[:ascii:]]//g' file > file.fixed
3

Hello

thanks for your answer. I have a dubt, where you put ascii I must replace by the ascii code of this point? or I execute the command just like you wrote?

I'll try anyway

Thanks

4

Execute it as it is now.

5

Ok,
very nice !! it works fine.

Many thanks again
Have a nice day !

6 
LANG=C tr -d '[\200-\377]' < infile
7

I can't read nor interpret the error msg, but I would be very curious where that "char" is coming from. The value is way beyond the UTF-32 code set, so how did it enter the DB in the first place? Maybe the input routines need some more error checking?

8

Hello
well, the data is stored into SQL server 2008, and the application front head is java via web, so users enter here and put the text ; The application give the option to use an editor msword like..So I suppose they are abble to put some special caracters.

I don't know more about this application.

Just if some one is looking for it, here is a good page with a lot of ascii characters:
Caracteres del c�digo ASCII | YouBioit.com