The Table tool from the Reporting tab is removing double spaces

[jmwagner]

I have created a workflow that puts together a table which then gets exported to excel per a certain group. There is one field in that table which contains folder paths. We have an instance where the folder path has a double space in it. When creating the output I want the folder paths to be untouched. When processing it through the Table tool it removes double spaces. Is there a setting that is causing this or is this a default procedure with the Table tool?

Thanks in advance.

[atcodedog05]

Hi @jmwagner 

Reporting tools using html logic at back end hence all double spaces and line breaks are removed. Follow the below post to insert the double space as required. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-th...

Hope this helps : )

[atcodedog05]

_

[atcodedog05]

Hi @jmwagner 

Here is how you can do it.

Workflow:

Output:

Reference post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Table-tool-removing-double-spaces/td-p...

Hope this helps : )

[DataDynamite]

I used this idea within a workflow that I needed to render to our Gallery with .pcxml.  The replace using " " worked on desktop but didn't in the gallery.  I found replacing with En Space (" " ) did work.    

Thanks!   DD