Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Is there any options to remove items from a list which starts with underscore.
_1,_2,_3 should be removed. It can have any number of items starting with underscore
List
A
B
_1
_2
_3
Tried List.removematchingitems that remove only exact match.
Thank you
Solved! Go to Solution.
= List.Select(YourList, each not Text.StartsWith(_,"_"))
Thank you. It works.
= List.Select(YourList, each not Text.StartsWith(_,"_"))