Table tool removing double spaces

Hi all,

I've seen the community "fix" for this by using the Alt255 instead of a space but that doesn't seem to work. Here's the scenario, I have a table tool that's being fed into an email. There's a column in the table that has 2 spaces but the table tool removes 1 of the spaces in the email. I've tried using the Alt255 in place of the space but see image below for result

Any help would be much appreciated! Am I missing something in the replace formula?

Example: 'ABC 123' (has 2 spaces)

Replace formula: Replace([ITEM]," "," ") -- held Alt and keyed 255 for the replacement section of the formula

with spaces.jpg Alt255 replacement.jpg

Reporting

Accepted answers

SVERHEYDEN

Solved! I found this article that got me in the right direction: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-the-Table-gt-Email-tools/td-p/89996

I actually ended up replacing the double space with a "|" prior to the table tool then adding a formula after the table tool to replace the new "|" with the HTML code for space " "

See attached for solution

SOLVED - sample for double spaces in table field.yxmd

All comments

TrevorS

Hello @SVERHEYDEN
Are you able to provide us a copy of your workflow as well as some sample data?

This will help the Community to better troubleshoot the issues you are encountering.

Thanks!

TrevorS

SVERHEYDEN

@TrevorS and fellow community, see attached sample. I've stripped out all previous steps in the workflow to simplify. Again, I need to be able to have the fields come through the table and email tools exactly how they are in the database. This means the ITEM_NO could have no spaces, 1 space, or many

sample for double spaces in table field.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703