1 Reply Latest reply on Jan 16, 2012 11:24 AM by philmodjunk

    Excel import -- do not import ""

    MikeF

      Title

      Excel import -- do not import ""

      Post

       

      Would like to set up validation where FM will import an Excel range, but will not import records within that range where, say, Price is equal to nothing ... "" [double quotations] are in the cell.

      Have tried a few different things but to no avail.

      Thanks,

        Mike 

        • 1. Re: Excel import -- do not import ""
          philmodjunk

          Assuming that field truly imports as empty, you can set a validation rule

          No IsEmpty ( ThatField ) with "validate always" enabled. This can even be on a different field as long as you have it somewhere on one of the fields.

          Then those fields should be omitted during import.

          The other options is to find and delete those records immediately after import--which is simple to do.