Forum Discussion
Solved
Split a cell into multiple columns
Hi All, I need your help again. 1/11 communication 1/10 communication 1/9 communication 1/6 communication 1/5 communication 1/4 I emailed the following: items a items b Above is th...
Indeed, the feature doesn't work in this case.
The code of the recorded code line is:
= Table.ExpandListColumn(Table.TransformColumns(Source,
{{"Spalte ""1""", Splitter.SplitTextByDelimiter("#(#)(lf)", QuoteStyle.Csv),
let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}),
"Spalte ""1""")By simply adjusint the part
Splitter.SplitTextByDelimiter("#(#)(lf)",
to
Splitter.SplitTextByDelimiter("#(lf)",
it works as desired.
Indeed, the feature doesn't work in this case.
The code of the recorded code line is:
= Table.ExpandListColumn(Table.TransformColumns(Source,
{{"Spalte ""1""", Splitter.SplitTextByDelimiter("#(#)(lf)", QuoteStyle.Csv),
let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}),
"Spalte ""1""")
By simply adjusint the part
Splitter.SplitTextByDelimiter("#(#)(lf)",
to
Splitter.SplitTextByDelimiter("#(lf)",
it works as desired.
