Forum Discussion
Alisea_MI
Resolver II
Resolver IIExtract string with MID without specifying the number of characters
Hi, I am new to Dax and I need to search for a text strings starting from the fourth character to the end of the string and if the text is there, return some other text. However, my string length...
Alisea_MI , Try a new column like
New column =
var _1 = mid([column],4 , len([column])
return
Switch(true(),
search("ST",_1,,0)>0, "ST",
search("LL",_1,,0)>0, "ST",
search("X",_1,,0)>0, right([column],2)
)
amitchandak
Super User
Super UserAlisea_MI , Try a new column like
New column =
var _1 = mid([column],4 , len([column])
return
Switch(true(),
search("ST",_1,,0)>0, "ST",
search("LL",_1,,0)>0, "ST",
search("X",_1,,0)>0, right([column],2)
)