SQZ=(SHIFT=LEFT) with IFTHEN

karthik_sripal · Posted: Tue Jul 09, 2013 12:32 am

Hi all,

I have a input record to be squeezed but if there is any spaces as the only value in the field - I would like to retain only one space.

could any of you please help how we could achive this

Input record

karthik_sripal · Posted: Tue Jul 09, 2013 12:43 am

Kind of arrived at the solutions

But is there any other intresting solution - I would like to know !

Bill Woodger · Posted: Tue Jul 09, 2013 12:54 am

I hink you're about there. You don't need both INREC and OUTREC. I assume you want the embedded blank to disappear from "DDD D"? The inclusion of the "," in your test isn't strictly needed (you shouldn't have another way to get "" together) and it would mean your code would not work if the first "column" of your CSV were "blank".