Forum Discussion
How can I force a delimited data source to not skip blank values in an Amount field?
I have a situation where I'm trying to load trial balances from QuickBooks. The source file I'm receiving has three comma-separated columns - Account+Description, Debit, Credit. QuickBooks has a qui...
JJones
OneStream Employee
OneStream EmployeeCan you give this a shot in a Parser Rule:
Dim defaultValue As Decimal = "0.00"
'Check the source value that was parsed
If args.Value.Length = 0 Then
'Nothing was found on this row, so return the default
Return defaultValue
Else
'This line has a value, so just return that value
Return args.Value
End If