In a data table, I have a column of room numbers, such as 103, 104, 208, 307, 409, 502, 604, 608. I would like to create a new column of floor for each value such as 1, 2, 2, 4, 5, 6, 6. I am not sure how to use the function option for this task. Can someone help with this?
Is the first digit the floor, this will work for rooms such as 1202 as well that are on the 12th floor.
you can do the following