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
ckattookaran's avatar
ckattookaran
VIP

From the look of it it is a parser rule and you can only use that inside a data source. If you are doing this on a multi culture environment and a finance rule there are xfstring that you can use for a cellamount method

SteveK's avatar
SteveK
New Contributor III
2 years ago

Good point on the multi-culture element from the XFxxxx equivalents of Replace etc. in VB.NET.

In this case I didn't need it, but I'll add in to V2.0!