Forum Discussion
Solved
How to split with space except one word
Hello everyone, I`m newbie in this forum, so I`m so sorry if I'm still not used to the way of communication in this forum. 【So the problem which I want to discuss is】 →I need to separate/split ...
You can apply steps below after your last step.
Replaced = Table.ReplaceValue(PreviousSteName,"not ","not_",Replacer.ReplaceText,{"commentar"}), Split = Table.TransformColumns(Replaced, {{"commentar", each Text.Replace( "(" & Text.Combine( Text.Split (_, " "), ") (") & ")", "_", " "), type text}}) in Split
Dear Jakinta
Thanks for you response, you solved my problem