30
I am building a CASE formula and want to base it off of if there is certain text in a field, specifically the letters "MG" that will be next to each other. I have tried contains and cannot figure it out.
Thank you for your help!
Hi David,
Yeah that's what I was thinking , we don't know until Debra explained the complete condition and that's why I said it would be a complicated one for report writer level.
RW Functions either from GP Power Tools or Dexterity will be more flexible and could cover more cases easily,
Hi Almas
It will require multiple calculated fields, but nested conditional calculated fields can create the equivalent of a case statement.
It would probably help if Debra explained the end result.
Also with GP Power Tools you can create custom RW functions that can look at any data or perform any calculation.
Regards
David
Hi DebraH,
It sounds more complicated to be carried out in report writer (if you are talking about report writer).
In my opinion it will take you to create multiple calculated fields and even not sure if it will work.
Hi Debra
I am assuming this is for a Report Writer calculated field.
You can use the User Defined function RW_Pos() in the system series
function returns integer OUT_pos;
in string IN_target; { The string you want to search in }
in string IN_search; { The string you want to search for }
in integer IN_start; { The position at which the search will start in the target string }
If it returns > 0 then the letters you are searching for exist in the string.
Hope this helps
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (