Textmate/BBEdit Column View

[stephen]

Is it possible with either of these editors to display a delimitted text file in a tabular format?

e.g. if I had a text file with records like this

1,"aaa",yes,34,"bbb",222,3333
2,"ddddd",no,,"xxxxxxx",0,1
3,"s",yes,1,"b",1,1

in my editor I want to display the records like this

1,"aaa" , yes,34,"bbb" ,222,3333
2,"ddddd", no, ,"xxxxxxx",0 ,1
3,"s" , yes, 1,"b" ,1 ,1

so I can see each column/field lined up in each row?

I can do it very easily on Windows with UltraEdit but can't find similar functionality on the Mac.

I do a lot of development work processing text files dumped from different databases and it's sometimes useful to display the columns. The files can sometimes be too big for Excel.

Thanks.