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

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.