Report Text Tool removing apostrophes and indentation

Hi folks,

Having an issue with Report Text Tool - it keeps removing apostrophes from my input text in the output.

For example, my input contains "David's", and output shows "Davids".

Is anyone else having this issue and is there a way to fix this?

Also, is there a way to keep indentation from input to output in a single Report Text tool, or would I need to do this with a few different tools, or is this even possible?

Thanks!

Reporting

Output

Help

Accepted answers

All comments

jarrod

Hi @Rachael_OS ,

i've not had any issues with the reporting tool to that extent. My attached workflow has text coming in as "David's" and it outputs correctly, so maybe there is something else going on there. if you click on the input arrow in the report text tool, do you see the text reading correctly?

For the indenting, are you referring to a newline in the text field that isn't rendering on a second line? if so, you can try splitting by \n then running through consecutive report text tools to "stack" the text. (or split to columns and reference each one in a single tool)

ReportTextTool_WithApos.yxmd

Rachael_OS

Hi jarrod,

Thanks for responding to me and apologies for the delay! I think I was unclear in my original query - the issue I'm having is that I'm putting text into the Report Text tool, but when I generate a Word doc, it's removing the apostrophes from the doc.

I'm also formatting the text I have in the Report Text tool, so I'm not sure if that's what is causing the issue - it seems to only be happening in this one workflow.

ChiKar

I am having the same problem Rachael. When I use the Render tool to output to a Word document, all apostrophes are removed. I am interested in any solutions that may come out of this thread.

Rachael_OS

I got around this by adding an extra apostrophe - e.g. instead of it's I would have it''s

oly

Looks like it's working well in the text, but not if the fields contain single quote / apostrophe.

For example if I have "Alteryx's email" column in my data table and define Report Text tool as follows:

Alteryx' email:

[Alteryx' email:A]

will produce the same result, and not the value of the field that I have.

I will use select tool to rename my field as "Email" and amend Report Text tool as follows:

Alteryx' email:

[Email:A]

In that case it will produce as expected:

Alteryx' email:

oly.medlicott@alteryx.com

Best,

Oly

Szymon_Czuszek

Hi Rachel,

I had the same issue today, and I found out that it was because I copied the text from the template, and the template had some weird formatting, which made Alteryx not recognise it as an apostrophe, but unknown sign, so it simply skipped it. Once I replaced the “fake” apostrophe with a real one from my keyboard, it outputted correctly. I hope this helps!

Best regards,

Szymon Czuszek

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703