1#2#3#4#5#6#7#8
INDEXOFARRAY(SPLIT("
","#"),6)
SELECT SUBSTRING(column_name, 6, 1) AS sixth_string FROM table_name;