Extract Amounts from dimension based on start and end point

[afourie]

Hi All,

I am very new doing this. I have a column with text for example:

##TEXT## - £123.00 - TEST 1 

##TEXT## - £4567.00 - TEST 2

I am looking to create another column/dimension that will extract the £ amount from my existing column and another that will extract the TEST bit, the last bit.

Can someone help me on how to do this please?

Thanks 

[Dawid]

Depending on your database’s dialect look up different way of extracting data from text like REGEXP_EXTRACT