Forum Discussion

JDL623's avatar
JDL623
New Member
2 years ago
Solved

extract text connected by an underscore from a string of text

Hi, Is there a way to extract a string of text connected by an underscore into a new column?

 

Thank you

Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    Hi JDL623 

     

    Give this a go:

    Text.Combine( List.Select( Text.Split([Description], " "), each Text.Contains(_, "_" )), ", ")

     

     

    I hope this is helpful

2 Replies

  • m_dekorte's avatar
    m_dekorte
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi JDL623 

     

    Give this a go:

    Text.Combine( List.Select( Text.Split([Description], " "), each Text.Contains(_, "_" )), ", ")

     

     

    I hope this is helpful