Re: dfsort remove spaces
The suggestion was mine alone, and not meant to imply that it came from you. That was not my intent. In the sketchy strategy I suggested, my past task involved some additional data manipulations other than differentiating various input formats. Philosophically I agree that multiple passes of data are not an optimal approach, but in my past I've done ad hoc and one off tasks where additional pass(es) supply simplicity to the effort. On Fri, Oct 9, 2020 at 3:39 PM Sri h Kolusu wrote: > >> I've borrowed and taken advice from Sri K. and that's > always proven to be the path of simplicity. > > Anthony, > > Honestly I would never suggest multiple passes of data. So I am not sure > when I suggested "n" outfil approach to handle pattern. > > Thanks, > Kolusu > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort remove spaces
Let's assume that 'n' patterns of input exist. Above we see two. Code 'n' number of OUTFIL statements, each with their own OUTREC constructs. Sorry I don't have an example to show but in the past I've seen many of what's being discussed. I've borrowed and taken advice from Sri K. and that's always proven to be the path of simplicity. On Fri, Oct 9, 2020 at 1:21 PM Paul Gilmartin < 000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > On Fri, 9 Oct 2020 13:02:26 -0500, Anthony B. wrote: > > >So create a second OUTFIL. > > > I don't understand what you're suggesting. Can you provide > details? I suspect that what Ron posted was not his entire input, > but other numbers of blanks might exist in a larger data set. > > >On Fri, Oct 9, 2020 at 11:43 AM Ron Thomas wrote: > > > >> Anthony - The file has data as below also > >> > >> 000657|VHO TRIVENTO RESERVA |MALBEC 750ML > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> 007762|FJAO PTO CAMIL |T1 1KG > >> > >> Hence , coding fixed length OUTREC will not solve the problem > > -- gil > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort remove spaces
So create a second OUTFIL. On Fri, Oct 9, 2020 at 11:43 AM Ron Thomas wrote: > Anthony - The file has data as below also > > 000657|VHO TRIVENTO RESERVA |MALBEC 750ML > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > 007762|FJAO PTO CAMIL |T1 1KG > > Hence , coding fixed length OUTREC will not solve the problem > > Thanks > Ron T > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: dfsort remove spaces
I don't understand why the solution is so complex. If the spaces all line up in fixed columns (I hope this assumption is correct), then simply coding OUTRECs for each field non-blank would accomplish the desired output. I've coded many hundreds of DF/SORT jobs and I don't see a degree of difficulty. If I'm missing something obvious, I'll appreciate clarification. On Thu, Oct 8, 2020 at 11:34 AM Paul Gilmartin < 000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > On Thu, 8 Oct 2020 10:46:00 -0500, Ron Thomas wrote: > > > >I have a sample file as below and we would need to remove the spaces > > > >000645|VHO CASILLERO DIABLO |PINOT NOIR 750ML | > >... > >i have coded as below > >SORT FIELDS=COPY > >INREC OVERLAY=(001:001,010,UFF,M10,LENGTH=10, > > 012:012,025,UFF,M10,LENGTH=25, > > 038:038,025,UFF,M10,LENGTH=25, > > 001:001,2500,SQZ=(SHIFT=LEFT)) > > > >but the output i am getting is as below > > > >645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO| > >... > Where did the "DEL" come from? > > -- gil > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
