Hello,
We currently have an SQL database which serves as our Identity source for the Work_Phone attribute. We use an Identity collector with an SQL driver to collect the "Phone" column from our database, and populate our Identity record with the phone number.
For some reason when we collect, certain phone numbers are appended with [NEW LINE] at the end. Example in screenshot. Has anyone else run into this issue and/or know how to resolve?
Thank you
Maybe there are additional non visible chars in the column.
Here is an example:
When executing the query with dump function, you can see that there are additional chars
Note: 10 in ascii is a new line.
You can try using the following SQL query:
Note: the SQL queries are from Oracle SQL