AnsweredAssumed Answered

RSA IG&L Data Collection Issue:  How to remove a hyphenated name or a name with an apostrophe (i.e. Smith-Jones or O'Malley)

Question asked by Larry Carter on Aug 24, 2018
Latest reply on Aug 25, 2018 by Pradeep Kadambar
  • Comment • 1

Client is using RSA IG&L 7.0.1.P05_HF02  is seeing hyphenation symbols and apostrophe punctuations in the name field of IDC, and ADC records collected and wants them removed and a process implemented in RSA to remove them.  Am looking for suggestions and recommendations to remedy this issue an example:  "John Doe-Re" or "George O'Malley"

Pradeep Kadambar
Pradeep Kadambar Employee Aug 25, 2018 3:17 PM
Correct Answer

If your collector is a CSV or a database then you can employ the REPLACE function to remove unwanted characters.

See the reply in context
No one else had this question

Outcomes