Forum Discussion
Split Columns by certain text
Thanks for the quick reply, I am getting the below error when I try and do this. I have been able to create a table but it only gives me a vew results and not all of them??
Hi ZachUnger
Please find the attached File
https://drive.google.com/file/d/1i7PknHFfTH8IQos818_s7IJPjazXgZ0v/view?usp=sharingHow to create Blank query
Right click on Left query pane and select Blank query
Then go to Advance Editor & paste the code
You are placing code in wrong place. see the attached file
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
Hello ZachUnger ,
so you click on the column then click on add columns then extract and then the first one use the text before delimiter to extract the PE , and the delemiter would be the dash - then you do the same but text after delimiter to extract CR.
check the extract by delimiter
https://learn.microsoft.com/en-us/power-query/split-columns-delimiter