Forum Discussion

SteveK's avatar
SteveK
New Contributor III
2 years ago

How to deal with an Amount Field that has space as a thousands separator AND a DR/CR indicator!

If you encounter an Amount field that has spaces as the thousands separator AND includes a DR/CR indicator (e.g. 12 345 678 D) then you'll need this to parse the value: Dim strRawAmount As String ...
Data Integration
Data Sources
Nokhez's avatar
Nokhez
New Contributor II
2 years ago

Where should we place this code?

  • SteveK's avatar
    SteveK
    New Contributor III
    2 years ago

    It's indeed a Parser Rule, so you can use it as a Complex Expression for the Amount field in a Data Source - or you could put it in a Business Rule for re-use if you have multiple Data Sources that need to do the same thing.