Forum Discussion
Migrate an Excel Formular to count csv delimiters
Hi Community, I'm quiet new to PBI and try to understand PowerQuery and M I do spend lot of time and become a master somewhen, but for now it stucks... What I have: csv file pipe | delimeted, n...
KT_Bsmart2gethe
Impactful Individual
Impactful IndividualHi dieling ,
if your intent is to split column by delimiter dynamically:
Table.SplitColumn(Source, "Test", Splitter.SplitTextByDelimiter("|", QuoteStyle.None))
if you are simply want to count the delimiter:
Table.AddColumn(Source, "Custom", each (List.Count(Text.PositionOfAny([Test],{"|"},Occurrence.All))-20)/2)
Regards
KT