Need to remove special character

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
Vikas.betu
Member
Posts: 29
Joined: Tue Feb 18, 2014 9:13 pm

Need to remove special character

Post by Vikas.betu » Thu Apr 17, 2014 8:11 pm

Hi

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

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Thu Apr 17, 2014 8:45 pm

Are you sure you need to remove them? All of them? Anywhere on your records?

Have a look at your documentation for FINDREP.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Apr 17, 2014 9:53 pm

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.
Have a good one

Vikas.betu
Member
Posts: 29
Joined: Tue Feb 18, 2014 9:13 pm

Post by Vikas.betu » Thu Apr 17, 2014 9:57 pm

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

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Apr 17, 2014 10:00 pm

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?
Have a good one

Vikas.betu
Member
Posts: 29
Joined: Tue Feb 18, 2014 9:13 pm

Post by Vikas.betu » Fri Apr 18, 2014 12:04 am

having some special charater like (" , Ì ) in my file. I need to replace these characters with Zero's or spaces.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Fri Apr 18, 2014 12:08 am

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.
Have a good one

Vikas.betu
Member
Posts: 29
Joined: Tue Feb 18, 2014 9:13 pm

Post by Vikas.betu » Fri Apr 18, 2014 1:14 am

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

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Fri Apr 18, 2014 1:56 am

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?
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others