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