I have a column in a source called Name, that typically contains the following data;
CN=INBAPARAG0001, OU=Paris, OU=Remote, OU=Clients,OU=Partners,DC=
Using the derived column transformation editor in SSIS, I want to create the following derived columns
CN OU DC
For the CN column I am thinking I should use a combination of the SUBSTRING Function and the LTRIM Function in the expression but I cannot guarantee that the CN value will be a consistent length,
Is there someway to tell the function that I want “everything returned as far as the first comma”?
Any guidance appreciated, thanks