Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
I have a text column where every value is a 12 character string of numbers and letters. I need some M code that checks whether the 7th letter is a number 0, that I can then incorporate into a conditional column function.
I assume Text.Middle is the one to use but I cannot find an example where it has been used for this purpose. Can anyone help?
Many thanks.
Solved! Go to Solution.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |