Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 the given sentence into single word by "space", but I don`t want the same treatment applied to any phrase begin by word "not"
【Exemple】
【Desired output】
the AC is not working : (the) (AC) (is) (not working)
the motor is not going well : (the) (motor) (is) (not going) (well)
I really appreciate to anyone who can help me solve the problem
Solved! Go to Solution.
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
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
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.