"contains"
1 Topic
Find multiple substring (not defined a priori) in a text
Hello everyone, I'm new to this forum and also to using Power BI Desktop. I was trying to solve a small issue I'm encountering. In practice, I need to be able to find words within a text contained in a row, let me explain it better. In a cell in column A, I have the string "A,B,C". In the cell in column B, I have the string "A,B,C,D,E,F,G,H,I". So, I need to check if "A", "B", and "C" are in "A,B,C,D,E,F,G,H,I". Similarly, if I have the string "C,B", I need to be able to check if "C" and "B" are in "A,B,C,D,E,F,G,H,I". The strings in the cells of columns A and B do not have a fixed number of elements; they can vary. The results is better explained here: Column A Column B Results A,B,C A,B,C,D,E,F,G,H,I True C,B A,B,C,D,E,F,G,I,N,P,Z True D,Z A,B,C,I,Z False Thanks to everyone who will help meSolved1.2KViews0likes4Comments