Re: smart formatting csv files
Well.... no real particular reason... I was just wondering a bit.
I guess I'll use Open Office :)
thx
Joao
On Thu, 2011-07-14 at 13:35 +0200, Lorenzo Sutton wrote:
> 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
> >
> >
> >
>
>
Reply to: