Hi, I’m cleaning up my massviews analysis data, but this is a question I need to know for other projects. In this case, I want to delete every row that has “Talk:” as the first five characters in a certain value. Is there a way to facet based on matching to a certain string?
Yes you can do this in a few ways but I’d suggest:
- Choose Facet → Custom text facet
- In the expression box enter
value.startsWith("Talk:")
This will create a true/false face where true will be all the rows where the cell text starts with the specified string
Best wishes
Owen
Text Filter is another alternative (where you could still use the All → Flag/Star rows or even just directly Edit rows → Remove matching rows). You can use a regular expression such as starts with ^ and then your chars ex. Talk: so completely the expression would be ^Talk:.
thank you! I was having the hardest time googling this.