The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Team
I'm wondering if there is an easy way to extract anything starting with CRC or PE into a new column as per the picture below.
Please note: some have multiple so I would need all of these possibly separated by a comma.
Any help appreciated
Cheers
Z
Solved! Go to Solution.
Hi @ZachUnger
In Power Query Editor, please create a custom column and use below code
Text.Combine(List.Select(Text.Split([#"PE (comments)"], " "), each Text.StartsWith(_, "CRC") or Text.StartsWith(_, "PE")), ", ")
If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
Proud to be a Super User! | |
Thanks, PijushRoy. This has resolved the issue.
You are welcome @ZachUnger
Proud to be a Super User! | |
Hi @ZachUnger
In Power Query Editor, please create a custom column and use below code
Text.Combine(List.Select(Text.Split([#"PE (comments)"], " "), each Text.StartsWith(_, "CRC") or Text.StartsWith(_, "PE")), ", ")
If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
Proud to be a Super User! | |
Hi @ZachUnger ,
Please post a sample data that can be copy-pasted to Excel (not an image). Questions:
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |