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

[OSAdmin]

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?

[OSAdmin]

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