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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |