Removing character before a symbol


#1

I have a list (Structural Column in this case) where the Column Location Mark is made out of a structure X - Y.

I’m trying to extract X (anything before the -) and Y (anything after the -) to a single list and then just keep the unique values.

I figure i can use List.UniqueItems once i deconstructed the initial list to get the Unique Values


#2

20150914-2