AnsweredAssumed Answered

Boolean Help

Question asked by amcbaldwin on Sep 18, 2018
Latest reply on Sep 18, 2018 by philmodjunk

I have a third party application that I am importing loads of data from in the form of CSV.  This ends up being a complex CSV file and the Application exports data in an odd behavior sometimes exporting a False field as "False" and sometimes a  "   ".  Currently, after importing, I have to run a Find/Replace for all "False" values and replace them with "    " to correctly have the database count the occurrences of true False.  I would like to build something like an auto entry to immediately catch these "False" values and turn them into "0" or "   " upon importing them.  I have tried the following equations in the auto entry but it does not appear to work correctly.

 

Substitute ( SSDefect ; "False" ; " " )

 

Substitute ( SSDefect ; "False" ; "0" )

 

Any ideas as to what I am doing wrong?

 

 

Thanks in advance

Outcomes