The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Support RegEx Multiline Flag

Although this could also effect ANY formula, the RegEx tool does not support a flag for Multiline.  Often incoming data contains multiple lines of data and the user must replace new lines and carriage returns with a space or other delimiter in order to operate a regular expression on all of the data.

 

RegEx has a multiline flag (for Alteryx it would be a checkbox) that allows it to handle each line separately.

 

domain.com

test.com

site.com

 

if these are individual records, then \w+\.com$ works wonderfully,  if these are all contained in a single EXCEL cell, then you need to write to community to figure out what to do.

 

Cheers,

 

Mark

2 Comments
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
ChrisTX
15 - Aurora

Here's a use case for being able to modify the /a (or /u) modifier:

 

\w not behaving as expected
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/w-not-behaving-as-expected/m-p...