In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Insensitive case in formula tool

faisal9999
8 - Asteroid

I have two srtings 

1. abc&fare$^{ifd)s

2. abc&FARE+ad(id)*fkvID

 

when I write down formula

 

if contains (columnname, "&FARE") then &FARE

elseif contains (columnname, "&fare) then &fare else '' endif

 

but result is coming &FARE for both rows. I want as it result if contains matching string.

7 REPLIES 7
binuacs
21 - Polaris

@faisal9999 try the below formula 

 

if contains (columnname, "&FARE",0) then &FARE

elseif contains (columnname, "&fare",0) then &fare else '' endif

flying008
15 - Aurora

Hi, @faisal9999 

 

 

IF REGEX_Match([Txt], '.*&FARE', 0) THEN '&FARE' 
ELSEIF REGEX_Match([Txt], '.*&fare', 0) THEN '&fare' 
ELSE Null() 
ENDIF

 

or

IF FindString([Txt], '&FARE') !=-1 THEN '&FARE' 
ELSEIF FindString([Txt], '&fare') != -1 THEN '&fare' 
ELSE Null() 
ENDIF

 

faisal9999
8 - Asteroid

Hi Dear, I have tried it but it is giving me blank

binuacs
21 - Polaris

Can you screen shot your formula here ?

JohnMcFadyen
5 - Atom

This is how I would have approached it. Works

binuacs
21 - Polaris
faisal9999
8 - Asteroid

thank you for the solution

Labels
Top Solution Authors