Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

olahnil
7 - Meteor

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?

3 REPLIES 3
joshuaburkhow
ACE Emeritus
ACE Emeritus

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

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
danilang
19 - Altair
19 - Altair

Hi @olahnil 

 

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

 

Dan

olahnil
7 - Meteor

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.

Labels