MS CRM Data Import Negative currency

I set up a Data mapping for data import in a custom entity. However, some currency amounts are being rejected if their format includes parentheses (signifying negative values) or commas. Is ther开发者_JAVA百科e any way I can tweak the xml in the data mapping to allow for these different formats? I'm working in MS CRM 4. Thanks!

Amount USDnew_period Process

---

Cannot you modify (Data cleansing by String Manipulation) the csv before submitting?