Remove Commas on Import
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?