Split Column HOW TO

[mn75224]

I currently have a column which contains a mix of digits and text. For example '$200 per ft for 53.163 feet for amendment' I would like to split the column so that I get two distinct columns with the following as the output "$100" and "53.163". How can I achieve this with the Split Column function? 

[sergej_og]

ok, seems you have a pattern. you described one above.
Target result something like this?

You will need few steps, but it is no coding extraction. That´s pretty cool.

[sergej_og]

Split Column function in PQ?
There are different possibilities to split by delimiter etc.

Do you have a pattern in your text you want to split? Has this text a logical structure where you can apply "Split Column by..." ?

[mn75224]

There is no pattern or logical structure except the fact that the cell will always contain a '$100' and a 'net ft' value whether that be a decimal or whole number