Hi,

I'm creating report using easy SQL. when download the item in Excel, i still have spaces at right.
I already used shiftl$(strip$(ticpr007.item)) at my report layout.

Does anyone can help me how?

thank you for the support.

I believe the item length is fixed in the report - is there a reason why you can't truncate it in excel? I used to do this all the time for when I was creating looks up things like that in excel that involved items.

The item length is follow the domain.
Whenever i download to Excel, i need to trim. So i need to to eliminate the spaces from the report. easier to download to excel.
so i have tried "shiftl$(strip$(ticpr007.item))" and "trim$(ticpr007.item)", but still have spaces at end. trailing spaces.

I think if you are using easy SQL then you will probably be stuck with the trailing spaces in the report. What you could try to trick the system is change item to is "shiftl$(strip$(ticpr007.item))" &"|". Then when it comes down to excel and when you do text to columns with | delimiter you might get the item without spaces in it. But then in excel you will end up with an extra blank column. Something to try at least.

yes. got it.Tq.
yes, if it we put in display, the report is weird.
but when download to excel, it is easier. i just delete the blank column.
:)
Tq. Mark.