Insensitive case in formula tool

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.

Datasets

Accepted answers

@faisal9999 try the below formula

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

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

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

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

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

Can you screen shot your formula here ?

This is how I would have approached it. Works

thank you for the solution