-SET &SPAC2='     ';
-SET &SPAC3='            ';
-SET &VALUE='HII';
DEFINE FILE CAR
SPACCOL2/A20 = '&SPAC2&VALUE';
SPACCOL3/A20 = '&SPAC3&VALUE';
END

TABLE FILE CAR
PRINT
CAR
SPACCOL2 AS 'COL1'
SPACCOL3 AS 'COL2'
ON TABLE PCHOLD FORMAT PDF
END
-EXIT

I am having a logic where in I need to add leading spaces to the data, in few columns. To show some Hierarchial stuff difference.

The code above works fine with PDF format. Where in, Excel the spaces are not added to the data. How to go about this ?

This message has been edited. Last edited by: Ramkumar - Webfous,

Try adding this statement to your code:

ON TABLE SET SHOWBLANKS ON

quote:

SHOWBLANKS

Thank you Dan... That worked like a charm !!

Yet another setting I knew nothing about. Thanks Dan! I think I'll need to tune in more frequently

Lovely! It works in HTML as well.

DEFINE FILE CAR
CTR/I2 WITH CAR = CTR + 1;
SPACES/A40 WITH CAR = '                              ';
CARNAME/A40 = OVRLAY(SPACES, 40, CAR, 20, CTR*2, CARNAME);
END
TABLE FILE CAR
PRINT
   CARNAME
ON TABLE SET SHOWBLANKS ON
ON TABLE PCHOLD FORMAT HTML
END

Arrrgh, I really needed something like this a while ago ... oh well, now I know better.

Thank you again Dan!