Alteryx Designer Desktop Discussions

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

Formula tool output inserts '·' instead of spaces

asteryx
8 - Asteroid

I am trying to feed a command string to the Run Command tool using a Formula Tool.

However, the command is unreadable because every space in the formula is read into the Run Command as a '·'.

 

I confirmed this in Notepad - it's not just a display issue.

 

Here's an excerpt from my Formula's Expression field:

<snip...> [Body] +' -H "Authorization: Bearer '+[Access_Token]+ <...snip>

 

And here is what shows up in the Input of the Run Command (I bolded the dots):

<snip...> /Body·-H·"Authorization:·Bearer·"00D <...snip>

 

Does anybody know where they come from and how to get rid of them? I can't compose any parameterized commands because of this.

 

Thanks.

11 REPLIES 11
JohnJPS
15 - Aurora

Yes - what Tom said: use the Cell Viewer to see the entire cell (e.g. if it's a very long line of text that won't fully display in the grid), and then the backwards P to turn off the dots.

asteryx
8 - Asteroid

Thanks for all your input, JohnJPS. Barking up the wrong tree, there!

Labels