Forum Discussion
JustSayJoe
Advocate IV
Advocate IVNeed more efficient "containsstring" method
I have a table (Advertising) with these three columns. Campaign Ad Set Ad Name Each of the columns are text strings that use multiple underscores as delimiters. The number of delimiters is not ...
then pls provide some sample data and the expected output.
ryan_mayu
Super User
Super Userthen what about not using containsstring function.
extract 125 in the PQ
or use DAX to extract 125
Column = mid('Table'[column1],FIND("_",'Table'[column1],1,0)+1,100)
JustSayJoeAdvocate IV
Advocate IVThank you for the response. My problem is, the values in the column do not maintain a standard naming convention, so there's a lot of cleanup after using PQ to split the column at the right most delimiter.
I'm thinking I may need to bear down and set aside a bunch of hours to manually clean up a ton of historical data...
- ryan_mayu
then pls provide some sample data and the expected output.