This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I have searched the blogs and posts to see if I can find an example for my situation, I want to wrap the text in one of the fields in my data set. I have 7 unique categories that I need the text wrapped before it feeds into the QVW data model and most posts are referencing using the RegEx Replace formula within the Formula Tool.
Could someone help me write the expression, and would I have to have 7 different expressions since I have 7 unique categories?
In your sample data both the values are already in the same cell? I assume you want to create a new line, but what criteria is there for pulling the word onto a new line, we could use after a certain amount of characters.
Alternatively we could use the dash.
To do the latter, you can use a replace statement.
Unfortunately not all Content Issues have a dash in the field name.
My initial thought was to use the find and replace tool and see if I could replace the original field entry with the new concatenated entry, but not sure how to include either a formula tool or RegEx tool to concatenate the Content Issues Field. I feel I am over-complicating the process and should be simple enough.
I am writing the regular expression and one issue I am facing is that one of the field line items is only one word and would not need a carriage return. However, can I still use ' ' in the second part of the expression to signify a blank carriage return?