Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, Is there a way to extract a string of text connected by an underscore into a new column?
Thank you
Solved! Go to Solution.
Hi @JDL623
Give this a go:
Text.Combine( List.Select( Text.Split([Description], " "), each Text.Contains(_, "_" )), ", ")
I hope this is helpful
Hi @JDL623
Give this a go:
Text.Combine( List.Select( Text.Split([Description], " "), each Text.Contains(_, "_" )), ", ")
I hope this is helpful
This worked perfectly. Thank you!