splitting delimiter in column and make exception

[Anonymous]

Hi guys,

Hope you can help me with this issue.

I'm Splitting a column by delimiter and it looks like this:

    #"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column1", "xxx", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"xxx1", "xxx2"}),

As you can see, I use "-" to split the text.

But I need to make an exception on it. 

If it recognizes "- SpecificWord" so don't split it.

Any idea how I can make it work?

Thank you!

[Anonymous · Accepted solution]

Hi,

Try using the below DAX to create the calculated column.

Here Data[Name] is the field which is to be split.

column_name =

VAR split_string = PATHITEM(SUBSTITUTE(Data[Name], "-", "|"), 2)

RETURN

IF( split_string == "specific string", Data[Name], split_string )

Thanks.