Erroneous Apostrophe in IM CSV Endpoint

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Suite

Issue/Introduction

Having defined a CSV (Flat File) endpoint for CA Idebnity Manager (IM) to hold user attributes which contain an apostrophe, the CSV export encloses these in more apostrophes than expected.
 

For example:

 

ORIGINAL - test's I

EXPORT - 'test''s I'

 

ORIGINAL - 't

EXPORT - '''t'

 

Environment

Release : 14.x

Component : IdentityMinder(Identity Manager)

Resolution

When you set up the CSV data source you are prompted to specify either an apostrophe ' or quotation marks " as the field delimiter.



If you are including apostrophes in the data source you should use quotation marks as the delimiter to avoid conflicts.