How to make the Oracle INITCAP function work to format raw data collected from a csv file during Identity Data Collection in RSA Via Lifecycle and Governance
Originally Published: 2016-07-21
Last Modified: 2022-06-20
Article Number
Applies To
Issue
Identity Data Collection having csv as the DB type and using driver class com.hxtt.sql.text.TextDriver
CSV file containing data to be collected by Identity Data Collection
In the example below, lines 2, 3, 7 and 9 have the emploees' first names and last names in all capital letters. These need to be formatted with a capitalized first letter of the word during collection (Michael Jackson vs. MICHAEL JACKSON).
The Oracle INITCAP function returns a character string with the first letter of each word converted to uppercase (also called title case).All other letters in the string are converted to lowercase.
The Oracle INITCAP function works as expected in Oracle SQL Developer.
The Oracle INITCAP function works as expected in Oracle SQL Developer.
When using the Oracle INITCAP function in the IDC User Data Query to capitalize the first letter of the first name and last name:
As in the example below, the first names and last names are not formatted correctly. Results after running the collection and verifying the raw data. Note the first name and last name are still in all caps.
Resolution
- Convert the string to lowercase using LOWER, then apply the INITCAP function.
INITCAP(LOWER(FIRSTNAME)) AS FIRSTNAME INITCAP(LOWER(LASTNAME)) AS LASTNAME
- Modify the collector definition "User Data Query" as follows:
- Run the collection and verify that the raw data are formatted correctly now; that is, that the first and last names' first letter is capitalized.
Related Articles
RSA Governance & Lifecycle Microsoft Exchange Connector Application Guide 7Number of Views RSA Identity Governance and Lifecycle - Microsoft Exchange Application Guide 74Number of Views Change Request Cancel and Revert is not Always Reverting Indirect Items in RSA Identity Governance & Lifecycle 13Number of Views SCIM 2.0 Data Collector and AFX Connector for RSA Identity Governance & Lifecycle 81Number of Views AFX Connectors remain in a Deployed state and Port 8585 already in use error in RSA Identity Governance & Lifecycle 474Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?