Hi johnirl,

Well you could write a regexpr for this of course, but I would suggest you to change the SQL-Statement instead. I don't know what kind of SQL etc you use for this but in sqlplus for example there are lots of options to format the output. If you use SQLPLUS, have a look at this manual.
If you want to use a perlish solution, I would simply but both columns in a seperate array, cut out the "---" and set $\ to "|".

giant