Start a new topic

Regular Expression: $xxx,xxx.00

I need a regular expression that will add the commas in accurately into dollar amounts. I have the $ and the .00, but no commas making it difficult to read. 


When you put numbers in to Raiser's Edge it auto-formats with the commas. For example, Typing/importing "10000" will show as "$10,000.00" in the database. If you are not seeing the punctuation, you may be missing your '1000 separator' which you can adjust in Configuration--International, as shown below.


image


That is on, but it is not importing correctly.

Odd! Can you post a picture of what the gift amount looks like after import? Also, check the Gift Currency Type from the Gift--Currency Exchange menu on the gift record. It may be changing to something other than dollars. 

image

Login to post a comment