Forum Discussion
Solved
extract specific text strings to new column (without using delimiters)
Hi I've just joined the community and hoping to get some help with the following. I have a single column in my dataset which contains two categories of data (all text) Category 1 consists of ...
NewStep=Table.SplitColumn(PreviousStepName,"Labels",each let a=Text.Split(_,";") in {Text.Combine(List.Intersect({a,{"MRI","RP","IPC"}}),";"),Text.Combine(List.Intersect({a,{"Strategic Advice","Grow Impact","Service Improvement"}}),";")},{"Teams","KPIs"})
NewStep=Table.SplitColumn(PreviousStepName,"Labels",each let a=Text.Split(_,";") in {Text.Combine(List.Intersect({a,{"MRI","RP","IPC"}}),";"),Text.Combine(List.Intersect({a,{"Strategic Advice","Grow Impact","Service Improvement"}}),";")},{"Teams","KPIs"})