In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

how to search string which has "-"

ferha_jafri
8 - Asteroid

Hello Experts,

 

I have to search for a string "INT-" so not sure as no string functions are not working with this.

 

Thanks in advance

5 REPLIES 5
mceleavey
17 - Castor
17 - Castor

Hi @ferha_jafri ,

 

You can use the Regex function to produce a matched output:

 

mceleavey_0-1620385942621.png

 

This will give a TRUE or FALSE response to whether or not the string contains Int-.

 

M.



Bulien

ferha_jafri
8 - Asteroid

I tried this but it did not work.

mceleavey
17 - Castor
17 - Castor

Hi @ferha_jafri ,

 

 

We need more information.

 

M.



Bulien

mceleavey
17 - Castor
17 - Castor

Hi @ferha_jafri ,

 

I've built it using Parse, and as you can see it works perfectly:

 

mceleavey_0-1620386858501.png

 

Workflow attached.

 

M.

 



Bulien

ferha_jafri
8 - Asteroid

This is all what I am looking for , I have a column on which I want to apply INT+ and INT- values and I want to apply filters on INT-

Labels
Top Solution Authors