I'm Having Trouble Currency to Padded Number

[LyndaEngelage]

I'm needing a rule to convert currency values to a 11 digit padded number. Examples are:


$265.39 to 00000026539
$43.90 to 00000004390
$765.00 to 00000076500


I thought the padded number rule would work but apparently with the $ sign and (.) in the data, it's not.


Any ideas?

[ThomasLewis]

You can use regular expressions to replace anything that's not a 0-9 with a blank. Your rule would look something like this:

return FormatNumber("00000000000", Field("Currency").replace(/[^0-9]/g, "") );