Hello

I have a sample file as below and we would need to remove the spaces

0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|VHO CASILLERO DIABLO     |PINOT NOIR 750ML          |
0000000645|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|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|
645|0|750|CASILLERODELDIABLO|VHOCASILLERODIABLO|

here we can see that the data "VHO CASILLERO DIABLO  " spaces also got removed 
. is there a way we can get data as follows

0000000645|VHO CASILLERO DIABLO|PINOT NOIR 750ML|

Could some let me know how this can be done ?

Thanks.
Ron T

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reply via email to