>I use this command a lot for quick drops of table data into Excel spreadsheets and it works great, except for one thing. It always PADS CHARACTER field data with spaces to the full length of the field. I'd like to know of a way to emlinate these padded spaces before I drop the data into Excel.
>
>I tried CHRTRAN(_CLIPTEXT, ' ' , '') and it almost works. The only problem is this funtion also eliminate and spaces embedded in the text strings so obviously this is not the correct solution.
>
>Thanks,
>Robert
Try
STRTRAN(_CLIPTEXT, ' ' , '')