How to convert string to decimal while removing unnecessary characters?

unknown

I am currently trying to create a derived field to convert the following value:

!1,082,965.72, !

into

1082965.72

I have tried to use a JavaFormat regular expression, but I don't believe it is working as expected. I can't think of another way to do this, does anyone have any suggestions?

andy

You could try something like this, though the derived field data type would prob have to be a string, so if you truly want a numeric value you might need another field to coerce the stripped string into a different data type...

for each (Char) YourSourceField split on "[!|s|,]"
    YourDerivedField += each(Char)

0712050808501819.doc