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

Hi, can somebody help me?

I have some strings that comes into alteryx like: "This is it." with more spaces in the sentence. But after the Alteryx creates the Excel sheet xlsx output then it automatically removes the spaces and creates a string like: "This is it." How can I force Alteryx not to do the inner trim automatically? We need the data with more spaces between the words.

In xls format the Excel keeps the spaces but if I want to create a formatted reporting tool based output there I only can find xlsx possibility.

Thank you

Datasets

Transformation

Data Investigation

Accepted answers

danilang

Hi @olahnil

This appears to be a known issue with the Table Tool. See here and here. To get around this issue you can replace the spaces in your strings with non-breaking spaces ASC#160. In Alteryx, you can use CharFromInt(160). These won't be removed in the output

In this example, both field1 and field2 started with the same strings. The formula tool replaces the spaces in field1 with ASC#160 giving this result.

The spaces are preserved in field1, but removed in field 2

Dan

StopTrim.yxmd

All comments

danilang

Hi @olahnil

In this example, both field1 and field2 started with the same strings. The formula tool replaces the spaces in field1 with ASC#160 giving this result.

The spaces are preserved in field1, but removed in field 2

Dan

StopTrim.yxmd

olahnil

Thank you, it is a perfect solution.

olahnil

Hi, 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 it does not accept the new space characters.

How can we solve this issue?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703