Log In
Register
Home
February 20, 2019
Offline
I extracted texts after delimiter (space), but I am not able to accomplish my task.
July 16, 2010
Offline
Hi Jim,
Can you please give me a pointer as to what the problem is. There are a ton of queries in your file and multiple tables, but I don't know what you're trying to do, where the source data is and the desired result, which query I should be looking at, or which step.
Thanks,
Mynda
February 20, 2019
Offline
Mynda,
Sorry for the inconvenience.
The Excel file: Summer Camp 2021 Classes_20210705.xlsx
The Query: SC-Fine Arts.
Step: Extract Text After Delimiter.
The Column: Courses (Almost toward the end)
The issues: 1.4 Beginner Taekwon-Do
After I perform this step (Extract Text After Delimiter) to extract texts after "space", some appear as Beginner Taekwon-Do (rows 8, 13, 19, & 25) while some appear as Taekwon-Do (rows 1, 5, & 6), missing "Beginner"
CSV sources file included in a zip file (SC-Fine Arts.zip)
You may also refer tot eh video: https://www.loom.com/share/79d.....786943c2d6
July 16, 2010
Offline
Hi Jim,
Thanks for pointing me in the right direction.
Power Query thinks the space after the course number in rows 1, 5 & 6 is a different character to the space in rows 8, 13, 19 & 25. I tried replacing them, but wasn't able to fix it. As a workaround, you can split the column by number of characters, with 4 as the number and then delete the column with the course number.
Hope that helps.
Mynda
1 Guest(s)
