SOLVED
Insensitive case in formula tool
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
faisal9999
8 - Asteroid
‎07-12-2024
01:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Data Investigation
- Datasets
7 REPLIES 7
binuacs
21 - Polaris
‎07-12-2024
01:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@faisal9999 try the below formula
if contains (columnname, "&FARE",0) then &FARE
elseif contains (columnname, "&fare",0) then &fare else '' endif
flying008
15 - Aurora
‎07-12-2024
01:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎07-12-2024
02:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Dear, I have tried it but it is giving me blank
binuacs
21 - Polaris
‎07-12-2024
02:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you screen shot your formula here ?
JohnMcFadyen
5 - Atom
‎07-12-2024
03:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is how I would have approached it. Works
binuacs
21 - Polaris
‎07-12-2024
06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-17-2024
12:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you for the solution
