AnsweredAssumed Answered

Remove Commas on Import

Question asked by sccardais on Sep 26, 2014
Latest reply on Sep 26, 2014 by philmodjunk

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? 

 

Outcomes