Exact test search in string by using CONTAINSSTRING

[Anonymous]

HI

We have a switch to map 

X =

SWITCH(TRUE(),

CONTAINSSTRING(Fact_DeliveryReport[Delivery Label],"_FR"),"FR",

we only need exact match

We see _FRE is also maped to FR

we only wanted  _FR not FRE  but with this FRE is  mapped to FR 

 We need only _FR = FR 

P_20190512_1700_CEU_S9W20_SUN_TAC_ALL_TEXT_ALERT_FRE

P_20190512_1700_CEU_S9W20_SUN_TAC_ALL_TEXT_SILENT_FRE

[Anonymous · Accepted solution]

@Anonymous  - You could try this:

X =
SWITCH(TRUE(),
RIGHT(Fact_DeliveryReport[Delivery Label],3 )="_FR"),"FR",
...

Cheers!

Nathan

[Mariusz]

Hi @Anonymous 

Can you give an example of FR without FRE, is it the last 2 characters or is it like _FR_ ?


Many Thanks

Mariusz