Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi,
You may refer to my solution here.
Hope this helps.
Thanks for the input Ashish! I'm wondering though if it's also possible to extract certain phrases and get a table/list output if the source cell contains a sentence and there are no delimiters.
Hi @enteron,
Please share sample data and show us desired output to make your requirement more clear.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
Sorry about that didn't realize the tables didn't show up as intended.
Phrases/Words to Match
Yellow Banana |
Red Apple |
Blue Berry |
Text StringList/Output
Green Banana, Yellow Apple, Blue Berry | Blue Berry |
Red Apple, Blue Berry, Green Banana | Red Apple, Blue Berry |
Yellow Banana, Red Apple, Red Berry | Yellow Banana, Red Apple |
Red Banana, Yellow Apple, Blue Berry | Blue Berry |
Thanks!
Not sure but is this possible?
Hi,
This is possible. Here is the result i got. I will share my solution in a couple of days.
Hope this helps.
Hi,
You may refer to my solution here.
Hope this helps.
Thanks for the input Ashish! I'm wondering though if it's also possible to extract certain phrases and get a table/list output if the source cell contains a sentence and there are no delimiters.
You are welcone. If my reply helpd, please mark it as Answer. I doublt if i can help you with your second question. Share the data and show the expected result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |