Forum Discussion
franzotti
3 years agoRegular Visitor
Search using the CONTAINSSTRING with " (quotes) in text.
I need identify the sizes for the monitor. How do i search using the CONTAINSSTRING for " (quotes) no Power BI ? SWITCH(TRUE(), (CONTAINSSTRING(Dim_CA_NumeroSerie[Modelo], " 22" " )), " 22" " ) M...
- 3 years ago
Sorry but do you only need the one who are a specific set of digits or am i misunderstanding, my english isn't native. My script returns all the sizes, no matter the characters.
Extreem sample:
edit:
if u want to check for a specific condition on the result you can do a check on the new column with either if or switch. for instance: if custom = 16 then 1 else 0
Waldo35
Helper I
3 years agothis takes the text between a space and a ".
"""" is interpreted as "
- franzotti3 years agoRegular Visitor
But my base is not standard and there are monitors using 4 digits (18.5") for the description and others with 3 digits for the description (27").
So I was using switch to identify only the specified ones.