Question

Extract Amounts from dimension based on start and end point

  • 27 June 2022
  • 1 reply
  • 63 views

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 


1 reply

Userlevel 7
Badge +1

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

Reply