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