Trying to Extract Town name

ChrisAZ what is the business logic to extract the name, in other words, if you hav toe do it manually what logic will you apply?

Do you have a list of known town names you can use as a reference?

ChrisAZ understood, but what defines the town name? How one will know what value is the town name in that text value of each row.

ChrisAZ do you have a list of town names that can be used to extract the value or there is a position of the town name in the text (my original reply for the logic) 

ChrisAZ getting there, so is it safe to say any value before "AB" or "BC" is a town name?

ChrisAZ although based on the sample data that also might not work because some town names have spaces. In that case, it will be safer to have a list of town names and then use that asa  reference to extract the name. 

Hi ChrisAZ,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you want remove certain values from rows of a columns and is looking for the best way to do it. As parry2k and Deku both responded to your query, please go through their responses and mark the helpful reply as solution.

I would also take a moment to thank parry2k and Deku, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.