Help with Derived column function (newbie question)

Question

Hi All
I have a column (first 3 rows shown below) & I need to extract out the part that falls between the $ (inclusive)  and the /. So for Row 1,  I want to extract $10, for Row 2 I want $100 and row 3 I want $29. These then need to be put into a new column. I assume this can be done using the derived column transformation. As a newbie - I am looking for the simplest way to do this.

Row 1 = 3G Browsing Pack $10/150MB
Row 2 = 3G850 HSDPA DTPK $100/150MB
Row 3 = 3G850 HSDPA DTPK $29/300MB
etc etc

Many thanks

Steve

Answer 1

Try this expression inside a derived column:
SUBSTRING(ID,FINDSTRING(ID,"$",1),FINDSTRING(ID,"/",1) - FINDSTRING(ID,"$",1))

ID is the column name.

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 2

Many thanks Nitesh. The expression did the trick.

Cheers

Steve