Forum Discussion
Removing all text except certain characters
Hello, I'm new to using PowerQuery and I'm trying to clean up a column on one table to create a relationship with another table. The column I'm attempting to clean up is a free text field from a ...
You can add a column with this formula, then remove the original column, and presumably filter out the rows that return null.
if Text.Contains([Column1],"MA-") = true
then Text.Middle([Column1],Text.PositionOf([Column1],"MA-"),7)
else null