Forum Discussion

Contributor III

2 years ago

Data Import: treat a dash a zero

Hi Is it possible to treat a dash/hyphen as a zero during a data import from a file? Thanks, Mark

Contributor

2 years ago

Perhaps a complex expression in the Amount field of the data source? Off the top of my head, maybe something like this:

If args.Value = "-" Then
	Return 0
Else
	Return args.Value
End If