Jeff,
> I'm having a hard time figuring out how to use split_part with a carriage
> return (hex 0a) as the delimiter. Would someone please offer me a clue?
0x0a is actually a new line. This works for me:
select split_part(text_column, E'\n', 1) from table;
--
GC