Forum Discussion

tonyenglish's avatar
tonyenglish
New Member
8 years ago
Solved

Extracting Text from a text string

Apologies if this has been asked before, but as a newbie to all things Power BI this is proving a bit of a pain.   The data I'm working with needs a certain bit of tidying before it's used.  One of...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi tonyenglish,

     

    You want to extract substring with the beginning of “SBCR” from [Activity], right?

     

    Click Query Editor->Transform->Split Column like belew.

    Column [Activity.2] is what you want.

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi tonyenglish,

 

You want to extract substring with the beginning of “SBCR” from [Activity], right?

 

Click Query Editor->Transform->Split Column like belew.

Column [Activity.2] is what you want.

 

 

Regards,

Jimmy Tao