AnsweredAssumed Answered

Allowing a hash sign "#" in a decimal field

Question asked by Gr8data on Dec 21, 2013
Latest reply on Jan 1, 2014 by Gr8data


Allowing a hash sign "#" in a decimal field


     Good afternoon. 

     I have a requirement, where I want to import values in to a decimal field eg 100.00, the source data might be a text field "100" but when it comes into FM, I want the value to be 100.00, which it does quite nicely when the field has been set up as a decimal field.

     The issue is the source data also contains a # in the field which represent an invalid value, which we want to keep. Any ideas how we can keep the decimal field but allow either a decimal or a # ?