Skip to main content
A
Anonymous
June 16, 2020

I have a data source with spaces instead of commas as the thousands separator.

  • June 16, 2020
  • 1 reply
  • 0 views
Originally posted by Jon Golembiewski

4/11/2018

I have a data source with spaces instead of commas as the thousands separator. I have tried the following to no avail:
Put |Space| in the thousands separator field in the amount column of the data source
Use the substitution settings to find/replace the space with either nothing or a comma
Use a complex expression to manipulate the amount
Anybody got any ideas to try to run into this before?

1 reply

A
Anonymous
June 26, 2020
Originally posted by Nick Kroppe

Dim amount As Decimal = args.Value.Replace("" "", String.Empty).xfconverttodecimal
If IsNumeric(amount) Then
api.ValueIsnumeric = True
Return amount
End If

Terms & ConditionsAccessibility statement