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

A function that exlcudes a list of numbers and/or characters from a string

Example:

 

Equipment IdTypeClean Equipment ID
123LLine123
123SSubstation123
S156Substation 156
123XBus123
123L6Delivery point1236

 

If I want to create the 'Clean Equipment ID" I would have to use a complicated RegEx expression. Wouldnt it be easier for the end-user to have a function to do so? Like Exclude(string,character)?

In this case it could be: exclude([equipment id],"ABCDEFGHIJKLMNOPQRSTUVWXYZ") and if I wanted just letters it could be exclude([equipment id],"0123456789").

 

3 Comments
jdunkerley79
ACE Emeritus
ACE Emeritus

Thnk this achievable wih a relatively simple regex:

REGEX_Replace([Equipment Id],"[A-Z]","")

This will remove all letters. Change [A-Z] to [0-9] to remove all numbers.

 

 

unshar
5 - Atom

This is worth gold! Thanks!

Community_Admin
Alteryx
Alteryx
Status changed to: Inactive