Insensitive case in formula tool

[faisal9999]

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.

[binu_acs]

@faisal9999 try the below formula 

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

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

[flying008]

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]

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

[binu_acs]

Can you screen shot your formula here ?

[JohnMcFadyen]

This is how I would have approached it. Works

[binu_acs · Accepted solution]

@faisal9999 

[faisal9999]

thank you for the solution