Hi Joao Ferreira Gmail wrote: > Hello all, > > I'm currently dealing with some big ugly csv files (separator is ';'). > I'm using gedit or kwrite to visualize them.
Any particular reason you won't use a software which can import/export csv? > Does anyone know if there is some kind of plugin ou external scripts for > gedit/kwrite that would allow me to align all that data vertically by > adding spaces where needed... the visual effect would be just like I > would get using a spreadsheet. > > I'dd like to go from this: > > a;aa;aaaaaaaaaa > bb;bb;bb > ;;ccccccc > > to this: > > a;aa;aaaaaaaaaa > bb;bb; bb > ; ; ccccccc A quick hack I can think of is in gedit search and replace all ';' with tabs ('\t') and then have a wide tab (depending on how wide each value is). Then just replace all tabs back to ';' to revert. This of course if you're 100% sure you have no tabs within the values themselves. Also make sure it is using real tabs not spaces. Lorenzo > > Thanks for any hints > Joao > > > -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/4e1ed49b.1020...@libero.it