Hi,

I am reading a field(its length - A64) in to variable as -READ STPDATA &STP.64. But when I try to use this variable in heading I was getting trailing spaces.So I used TRUNCATE for this.Now,though I am not gettting any trailing spaces,I am getting one leading space,which appears as a box in exl output.I tried using TRIM but it did not work.Could you tell me how to remove it?

Thanks !!

This message has been edited. Last edited by: Kerry,

Saggy,
Can you please post a bit of your code to show what exactly it is that you're doing? That would make it a lot easier for us to try and find out what's happening.

You can also use the LJUST function:

X1  /A10    = ' XXXX';        
X2  /A10    = LJUST(10,X1,X2);

hello ac1

Thanks a lot! LJUST worked !!!