7 Replies Latest reply on Sep 26, 2014 8:30 AM by philmodjunk

    Remove Commas on Import

    sccardais

      Title

      Remove Commas on Import

      Post

      Every month, I import an updated version of a Customer file containing several thousand records. This source document contains commas in the OrgName field that ultimately creates problems when I export to a spreadsheet used by a third party.

      I can easily remove the commas with a search and replace but I have to do this every time I import (Update matching and Add New).

      Is there a calculation to remove these commas automatically that I can insert in the Validation tab of the Field Definitions dialogue?