We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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