|When using the Oracle INITCAP function in the User Data Query of the Identity Data Collection having CSV as DB type and using driver class com.hxtt.sql.text.TextDriver, the Oracle INITCAP function does not capitalize the first letter of the word in the raw data collected.|
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.
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.