Forum Discussion
rishabjain237
Helper I
Helper ISplitting a column in Power BI based on a condition
Hi community, I have a column which has Google analytics event names It contains event names as : rd_dwn_smpl_key_trends_form_submit rd_dwn_smpl_left_red_form_submit rd_dwn_smpl_top_blue_from_su...
No the QuoteStyle.Csv is not missing, I'm suggesting you use another splitter, change it to Splitter.SplitTextByAnyDelimiter as illustrated in my previous reply
m_dekorte
Resident Rockstar
Resident RockstarHi rishabjain237 ,
Create a split column step with the User Interface using one of the words, then update the section made bold to the expression below:
Table.SplitColumn( prevStepName, "ColName", Splitter.SplitTextByAnyDelimiter({"form", "from"}), {"Event1", "Event2"})
I hope this is helpful