Page 1 of 1

Need to remove special character

Posted: Thu Apr 17, 2014 8:11 pm
by Vikas.betu
Hi

I have file which is having some special charater like (" , Ì ). I need to remove these character. Please help me out in this

Posted: Thu Apr 17, 2014 8:45 pm
by William Collins
Are you sure you need to remove them? All of them? Anywhere on your records?

Have a look at your documentation for FINDREP.

Posted: Thu Apr 17, 2014 9:53 pm
by DikDude
Suggest you post some of the input records your process will handle and then show the expected output.

If the data is to be kept secret, substitute some test values for these fields.

Posted: Thu Apr 17, 2014 9:57 pm
by Vikas.betu
Yes but I don't have the exact position.
I was using below code to remove special character
OPTION COPY
ALTSEQ CODE=(0040,0140,0240,0340,
0440,0540,0640,0740,
0A40,0B40,0C40,0D40,
0E40,0F40,1040,1140,
1240,1340,1440,1540,
1640,1740,1840,1940,
1A40,1B40,1C40,1D40,
1E40,1F40,2040,2140,
2240,2450,2540,2640,
2740,2A40,2B40,2D40,
2E40,2F40,3240,3440,
3540,3640,3740,3B40,
A140,7940,5A40,7C40,
7B40,5B40,6C40,B040,
5040,5C40,4D40,5D40,
6D40,6040,4E40,7E40,
6A40,E040,C040,BA40,
D040,BB40,7A40,5E40,
7D40,6F40,6140,6E40,
4B40,4C40,6B40,FC5A,
5AFC,E0EC,4A63,A159,D0DC,
6ACC,C043,43C0,59A1,634A,
7CB5,B57C,CC6A,DCD0,ECE0,
3D40,3F40)
By using this I am able to replace some of the special character.
so please provide some help in this

Posted: Thu Apr 17, 2014 10:00 pm
by DikDude
As mentioned, you need to post some data. . . .
"By using this I am able to replace some of the special character.
so please provide some help in this"
I do not understand what help you are looking for?

Posted: Fri Apr 18, 2014 12:04 am
by Vikas.betu
having some special charater like (" , Ì ) in my file. I need to replace these characters with Zero's or spaces.

Posted: Fri Apr 18, 2014 12:08 am
by DikDude
Why did you repeat your original request? It does nothing to clarify why you still need help.

The ALTSEQ should change those characters if you have all of the values in the character conversion list.

Posted: Fri Apr 18, 2014 1:14 am
by Vikas.betu
Dik
I am sayiing that I am not able to replace these characters through ALTSEQ. My question is how to replace. Is there any other way to replace these

Posted: Fri Apr 18, 2014 1:56 am
by DikDude
There are exactly 256 hex values that will fit into one character.

ALTSEQ has no restrictions that I am aware of, so every character can be replaced. For example the " is an x'7F' which I do not see in your list of codes?