How do I convert row_index and column_index to well positions?

You will notice that that Benchling warehouse tables store positions in plates and rack container types in columns called row_index$ and column_index$. To convert these positions into the more common plate-well format you can use the function below.

concat(chr(65 + row_index$), (column_index$ + 1))

#Example SQL
SELECT plate_id$ as "Plate Id", 
row_index$, 
column_index$, 
concat(chr(65 + row_index$), (column_index$ + 1)) as "Well Position"
FROM well
ORDER BY row_index$,column_index$


#SQL Output

Plate Id  | row_index$ | column_index$  | Well Position
96Well001 | 0          | 1              | A1
96Well001 | 0          | 2              | A2
96Well001 | 0          | 3              | A3
96Well001 | 0          | 4              | A4
96Well001 | 0          | 5              | A5
96Well001 | 0          | 6              | A6