converting a data item (removing currency sign)

[juleshsol]

Hi
I have a mental block. A data item (brought through from a collection will be '£100.00' and I want it to just read '100'. How can I amend this?
Thank you

 

[Sachin_Kharmale]

Replace "£" to "" it will work

 

[anjali]

More reliable solution will be to create a regular expression where you pickup only digits from a given string . It will ignore all the currency symbol (£,$, etc)