You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
Power BI:
I bet you can do this but how?
I have a field, with many different values like
Text1-text2-text3
Where
Text 1 might be supermarket
Text 2 might be Sainsbury
Text 3 might be s
Where - replaces space and special characters.
It's a free text column, but I'm guessing there will be shared commonalities like
Supermarket
Restaurant
Bar
Pub
You can see where this is going.
What I want to do is probably
Switch when supermarket to supermarket
Pub to pub
Bar to pub
Etc
But I don't want to manually write the switch. I'm guessing there would be a way of comparing strings and finding groups and I can see it in my head as
Split at - count number of times text1 appears in field overall etc etc.
Am I making any sense?