Removing special character

[paranoid]

Hi,

One of your jobs is failing daily due to a special character in the input data where we need to manually delete that special character and loading the data.

Eg:

Input data : SDS22MM SDS bushing 22mm ID ¼ key

I guess, the input source might have had the data as A to the power of 1/4 and during its import to a text file it is being converted to 2 characters as ¼ and this resulting in the increase of the record length and getting failed.

Appreciate your help.

Thanks in advance
Sue

[ray.wurlod]

Find out what that character actually is, using a hex viewer such as the od -xc command in UNIX or an editor like UltraEdit. Then you can use an appropriate Char() function to represent that character and either remove it or convert it to something else.

Just be sure that it's valid (according to the data owner's rules) to remove characters from their data.

You may need the special form of the Char() function if you're dealing with characters in the top half of eight-bit ASCII. The undocumented second argument is a true/false value that enables the use of the high-order bit. For example

Code: Select all

Char(164,@TRUE)

[dbdecoy]

thanks

[paranoid]

Hi Ray,

BY using the command od -cx for the line SDS22MM SDS bushing 22mm ID ¼ key, i got the following output:

0000000 S D S 2 2 M M S D S b u s h
5344 5332 324d 4d20 5344 5320 6275 7368
0000020 i n g 2 2 m m I D 302 274 k
696e 6720 3232 6d6d 2049 4420 c2bc 206b
0000040 e y
6579
0000042

Plese help me out in intrepreting this.

Thanks again
Sue

[ray.wurlod]

Can you please wrap that in Code tags so that the spacing is not lost?

[paranoid]

Code: Select all

0000000   S   D   S   2   2   M   M       S   D   S       b   u   s   h
            5344    5332    324d    4d20    5344    5320    6275    7368
0000020   i   n   g       2   2   m   m       I   D     302 274       k
            696e    6720    3232    6d6d    2049    4420    c2bc    206b
0000040   e   y
            6579

[chulett]

Code not quote. Fixed.