Add Column in order to separate data from existing column

[Amber_McLeod]

Hi,

I am trying to separate data in a column that can appear in the original column with or with or without delimiters.

Example 

Each of the below representssome of the potential entries in original column by row:

[string 1, string 2, string 3]

[string 2, string 4, string 5]

[string 1, String 2, string 4, string 5, string 7]

[string 1]

[string 2]

Because the delimiter could be present or not the eliminates the possibility of extraction using a delimiter, because the strings don't always appear in the same order, that eliminates extracting by chatacters. I tried adding a conditional column, maybe I entered that incorrectly but it errored out on me.

There are null values in the column but if in my conditional operator using contains string2, then return string2, else blank, I was thinking that should work, and I can't understand why it isn't working. 

I appreciate any help you can provide.

Thanks,

Amber

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523