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. 


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

That is on, but it is not importing correctly.

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


Login or Signup to post a comment