Working with Bitmask Database Values Using Excel
April 7, 2021 Leave a comment
In this video, we explore a real-world problem where the database stores an important value (in this case whether a group has administrative rights) in a bitmask format. We export the results to Excel and then use formulas to display the column value and our desired mask in binary format. We then use the BITAND function to determine which of our values have that mask value set.
Subscribe to My Channel
Platte Canyon/Jeff Rhodes Blog 