X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Parsing Text From String In Power Bi    
post Feb 13 2020, 03:06 PM

Posts: 172
Joined: 16-July 03
From: Northern MN

Hello all,

Coming for help again. Is there a straight-forward way to parse the first 3 words from a string of text that may contain 20 words, all separated by a space? I really need to have this in a column so I can display the first 3 words within Power BI visuals / Filters.

As always, help here is so awesome and much appreciated. Thanks in advance for the help.


Go to the top of the page
post Feb 13 2020, 05:44 PM

Posts: 3,835
Joined: 27-February 09

You could split it in PowerQuery on the space and just discard the other columns it generates. (Might get really messy if you have lots of words in there). Then you could discard all of the generated columns except for the ones you need, and then reassemble using a custom function.
This post has been edited by MadPiet: Feb 13 2020, 05:54 PM
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    3rd August 2020 - 03:52 AM