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: 7306

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: 7306

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 Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am


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