SELECT * FROM unpack (
ON ville_tempdata1
InputColumn ('packed_temp_data')
OutputColumns ('city', 'state', 'temp_f')
OutputDataTypes ('varchar', 'varchar', 'real')
ColumnLength ('9', '9', '4')
Regex ('(.*)')
RegexSet (1)
Exception ('true')
) ORDER BY sn;