How to split based off of space and a number?

[BAFreedom]

How do you split a colun such that it splits where the delimiter is a space and number?

Eg. Without quotations:

" 1"

" 2"

" 3"

 etc.

Thanks.

[Anonymous · Accepted solution]

Hi @BAFreedom ,

Your data has to be organized in a way that the space is after a identifier in your data set. Then you can run the extract function in power query to only take values after the delimiter _ .

1. _ 32
2. _ 35
3. _ 36

If it is not, you could try using the function in Power Query which is explained here

https://community.powerbi.com/t5/Desktop/Power-Query-Insert-a-character-to-a-string/m-p/349199

Hope that helps!

[BAFreedom]

Thanks! Definitely helps!!

[amitchandak]

@BAFreedom , Power query Split column by Delimiter or use Trim - https://www.youtube.com/watch?v=FyO9Vmhcfag

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4