Inner trim after converting to excel - how to deny it? version 2

[olahnil]

This is the history: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Inner-trim-after-converting-to-excel-h...

It seemed that the process in the attached linked solved our issue, but I have a new issue with this space character.

If I convert the spaces to ASC#160 then our load file fails to upload in the system,

because our system does not accept the new space characters.

How can we solve this issue in Alteryx?

[joshuaburkhow]

Is there some other character that can be used? Have you figured out why the system isn't taking those characters? 

[danilang]

Hi @olahnil 

What is the target system?  Can you give us any details?  

Dan

[olahnil · Accepted solution]

Problem is solved: Our system does not accept ASCII characters that is why this double space does not work. But it turned out only the reporting tool's outputs create trimmed excel. If we use normal output tool excel output then it works. The excel looks not nice but we can work with it. Thank you for your efforts.