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, "") );