Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Cream_17
Regular Visitor

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 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】

Cream_17_0-1680403014578.png

 

【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

1 ACCEPTED SOLUTION
Jakinta
Solution Sage
Solution Sage

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

 

Jakinta_0-1680410677675.png

 

View solution in original post

2 REPLIES 2
Cream_17
Regular Visitor

Dear Jakinta

 

Thanks for you response, you solved my problem

Jakinta
Solution Sage
Solution Sage

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

 

Jakinta_0-1680410677675.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors