Data Import: treat a dash a zero

[MarkBird]

Hi

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

Thanks,

Mark

[EricOsmanski]

You could through a rule on the Amount field, but in an attempt not to go that route you could try to Substitution settings on the Data Source Amount field. I have not tested this particular situation though.

[MarkBird]

Thanks Eric, I'll give that a try.

My only concern is that it may cause an issue with negative values?

[TonyToniTone]

Delete original post

[photon]

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