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