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

Reply via email to