Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I need help with using Text.Starts with. I want to test the first character of a string. If it is any capital letter (A..Z) then return "Letter", if it starts with a "1" then return "It's a 1" else "Not a letter or a 1". I can't figure out how to test for the first case (A..Z).
Any help would be appreciated!
Solved! Go to Solution.
Use following (replace Column1 appropriately)
if List.Contains({"A".."Z"},Text.Start([Column1],1)) then "Letter"
else if Text.Start([Column1],1)="1" then "It's a 1"
else "Not a letter or a 1"
You nailed it! Thank you very much!!
Use following (replace Column1 appropriately)
if List.Contains({"A".."Z"},Text.Start([Column1],1)) then "Letter"
else if Text.Start([Column1],1)="1" then "It's a 1"
else "Not a letter or a 1"
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
69 | |
24 | |
18 | |
13 |