Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

Without regex you would use substr (string,start_pos,substring_length) which can be irritatingly verbose, let me tell you. If JohnTitor used an inline view, something like: substr (payload_name ...

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.