Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to delimit data with '|' which has quotes and apostrophe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
gch77

New User


Joined: 16 Mar 2009
Posts: 13
Location: Chennai

PostPosted: Wed Aug 13, 2014 9:16 am    Post subject: How to delimit data with '|' which has quotes and apostrophe
Reply with quote

My input is :
Code:
FIRST" NAME                     123456789ADDRESS LINE '1


and I need the output to be:
Code:
FIRST" NAME|123456789|ADDRESS LINE '1|


I tried using the SQZ/JFY options in DFSORT as below.

Code:
//SYSIN    DD *                                             
   OPTION COPY                                             
   INREC IFOUTLEN=88,                                       
    IFTHEN=(WHEN=INIT,                                     
     BUILD=(1:1,50,JFY=(SHIFT=LEFT,LEAD=C'"',TRAIL=C'|"'),     
     54:51,9,JFY=(SHIFT=LEFT),C'|',                         
     64:60,24,JFY=(SHIFT=LEFT,LEAD=C'"',TRAIL=C'|"'))),
    IFTHEN=(WHEN=INIT,                                     
     OVERLAY=(1,88,SQZ=(SHIFT=LEFT,PAIR=QUOTE))),       
    IFTHEN=(WHEN=INIT,                                     
     FINDREP=(IN=C'"',OUT=C''))                         
/*


But it works perfectly only if my data doesnt have double quotes.

Please suggest me on how to handle this if data has " and ' also.

Thanks.
Back to top
View user's profile Send private message

gch77

New User


Joined: 16 Mar 2009
Posts: 13
Location: Chennai

PostPosted: Wed Aug 13, 2014 11:22 am    Post subject: Reply to: How to delimit data with '|' which has quotes and
Reply with quote

Please advise icon_sad.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7279

PostPosted: Wed Aug 13, 2014 11:31 am    Post subject: Reply to: How to delimit data with '|' which has quotes and
Reply with quote

Use FINDREP to change problematic character to a value which can't naturally occur in your data (X'FD', something like that). Then, after processing, use FINDREP to reverse that change.
Back to top
View user's profile Send private message
gch77

New User


Joined: 16 Mar 2009
Posts: 13
Location: Chennai

PostPosted: Wed Aug 13, 2014 11:58 am    Post subject: Reply to: How to delimit data with '|' which has quotes and
Reply with quote

Perfect ! thank you. it just dint strike me before. Thanks a lot.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7279

PostPosted: Wed Aug 13, 2014 12:00 pm    Post subject: Re: Reply to: How to delimit data with '|' which has quotes
Reply with quote

gch77 wrote:
Please advise icon_sad.gif


You're lucky I didn't see that before posting. You want it quick, you want to ask how it's going, then you find someone to pay to do it.

Here, you come for free. Acting like you're paying for it tends to reduce your chance of an answer.

It is not a complex process to come up with the answer. "This character causes a problem - if only it weren't there..." but "I do need that character after I've finished messing around".
Back to top
View user's profile Send private message
gch77

New User


Joined: 16 Mar 2009
Posts: 13
Location: Chennai

PostPosted: Thu Aug 14, 2014 9:00 am    Post subject: Reply to: How to delimit data with '|' which has quotes and
Reply with quote

Quote:
You want it quick, you want to ask how it's going, then you find someone to pay to do it.

Here, you come for free. Acting like you're paying for it tends to reduce your chance of an answer.


Sorry. I was also trying at my end to resolve the issue but just wanted seek some expert help who could give me a hint so that I shall change the way of my attempt to resolve the issue.

Thanks for helping me.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm
No new posts Sorting group data rajella DFSORT/ICETOOL 4 Sun Jan 22, 2017 11:32 pm
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us