Replace Two Qutoes by One Quote

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Replace Two Qutoes by One Quote

Postby knobi » Tue Jan 19, 2021 5:46 pm

Good morning, I've DFSort job doing many things, and so far it's running without problems.
Now data format has changed and we start receiving lines with consecutive quotes.
How could I replace two consecutive quotes by One quote ?

Input :
' ajskdjaskj '    '    aksjdkasjdkjdk'

Output :
' ajskdjaskj '    aksjdkasjdkjdk'

Quote's position doesn't really matter. Only one is gone.
I'm trying with this but with no success :

Any help is welcome ! Thanks
Posts: 9
Joined: Thu Aug 13, 2009 9:36 am
Has thanked: 0 time
Been thanked: 0 time

Re: Replace Two Qutoes by One Quote

Postby sergeyken » Tue Jan 19, 2021 9:37 pm

The syntax of your FINDREP is wrong.
This job cannot run at all; RC=8, or 12 is expected

Please, present your code which can run without SORT errors

It is not clear from your example, what is the expected “correct” output?
There are no “double quotes” at all...
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
Posts: 278
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 5 times
Been thanked: 25 times



  • Related topics
    Last post