Forum Discussion
chavanr
4 years agoResolver I
Need to clean data using LIKE function or in M query.
Hi there,
I am trying to clean a column
in the above screenshot. e.g. Furniture, Mattresses, Other, Pallets, Gardenwaste is a category which i want to seperate in another column. Also there is a description in some rows like "full bottles of fizzy..." and other rows above it.
i want it to be blank as it does not belong to any category.
Can i use LIKE function in M query
Cheers,
chavanr , See if Text.Contains can help
1 Reply
- amitchandakSuper User
chavanr , See if Text.Contains can help