I have mapped a field Customer number to Remote key in MDM system.For the records which are without customer no, remote key will be generated, but for records with Customer number, it will be directly created as new customer with same Customer number from the input file. Here the issue is, when loading records in MDM system via MDIS, some data have been worongly updated with customer number having "," in the end. Now the requirement is to delete those records from MDM system, but we have more than 6000 records got updated. Since few data has comma and few are correct, i am feeling difficulty in identifying those records. Coz for checking itself i need to select and go to edit key mapping and see whether is it right data or not.
Can any one suggest me in creating a validation to this scenario for identifying records having comma "," in their remote key field.
Any other solution is warmly welcomed.