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.
Solved! Go to Solution.
@faisal9999 try the below formula
if contains (columnname, "&FARE",0) then &FARE
elseif contains (columnname, "&fare",0) then &fare else '' endif
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
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