topic Re: Wrap Text not working when concatenating two strings in ArcGIS Insights Questions

Wrap Text not working when concatenating two strings

BlairMcclenathan — Wed, 22 May 2024 13:37:30 GMT

I currently have a reference table in one of our Insight pages that uses the following formula "IF(ISNOTNULL(project_completion_date),project_name+"°",project_name)" to add a degree symbol so I can conditionally format a column if the project has been completed.

The issue we are having is even with the column being configured to wrap text, once the degree symbol has been concatenated, text will stop wrapping. It works as intended if the if statement resolves to false. This behavior persists even when using the CONCATENATE function rather than the '+' operator.

**The highlighted row should say "Brookwood Way Bridge and Home Demolition°". The whole name appears when hovering over the cell or if you manually adjust either the width or height of the row. Also shown are the un-concatenated names which have proper wrapping**

Re: Wrap Text not working when concatenating two strings

AkshayHarshe — Wed, 22 May 2024 17:53:39 GMT

@BlairMcclenathan Thanks for reporting this. We will take a look.

Re: Wrap Text not working when concatenating two strings

AkshayHarshe — Mon, 10 Jun 2024 17:19:46 GMT

@BlairMcclenathan I looked into this and this is not specific to the calculated field the conditional formatting is causing the problem. You do not see the ° sign because the text is not wrapped. I have logged an issue for this.

Re: Wrap Text not working when concatenating two strings

AkshayHarshe — Thu, 13 Jun 2024 20:12:22 GMT

@BlairMcclenathan This should be fixed in the upcoming release 2024.1.

Re: Wrap Text not working when concatenating two strings

BlairMcclenathan — Thu, 20 Jun 2024 15:56:23 GMT

@AkshayHarshe Great thank you for the updates!