Forum Discussion
Solved
Extract multiple text
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 the...
Hi ZachUnger
In Power Query Editor, please create a custom column and use below codeText.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
