Menu ▾ ▴

Column Align of a csv file

[READ ONLY] Help
Nobody/Anonymous
2007-12-28
2012-11-13

  • Nobody/Anonymous

    Nobody/Anonymous - 2007-12-28

    I've a delimited file such has :

    21.08.2007;DJX;0.8791991;
    21.08.2007;NASDAQ;0.07685496;
    22.08.2007;DJSTOXX;-1.7085667;
    22.08.2007;DJX;0.8341648;

    and I would like to have it column aligned :

    21.08.2007;DJX    ;0.8791991    ;
    21.08.2007;NASDAQ ;0.07685496   ;
    22.08.2007;DJSTOXX;-1.7085667   ;
    22.08.2007;DJX    ;0.8341648    ;

    This can be done in pspad but not in notepad++ ?

    Thanks

     

    • Nobody/Anonymous

      Nobody/Anonymous - 2007-12-28

      Guess not. You could replace the ;'s by TAB's and set the Tab Size to a big number, but this will also make small columns wider than needed.

      By the way, try using _'s to represent space(s), since these are truncated.