View a CSV file as a tab separated file

2012-10-18
2012-11-13
  • Yash Kapoor
    Yash Kapoor
    2012-10-18

    I have a simple note pad file which looks like this:

    The,3,ABC
    Length,6,PQR
    Of,2,JKL
    Columns is,9,XYZ
    inconsistent,12,LMN

    This is what i wish to achieve using N++ or any other viewer/editor:
    The, 3, ABC
    Length, 7, PQR
    Of,         9, JKL
    Columns is, 5, XYZ
    Inconsistent, 1, LMN

    I know this can be done using the import wizard in excel, but i only need to look at the data and not append it. So, importing to excel helps, but is time consuming and unnecessary

     
  • Dejan Kozina
    Dejan Kozina
    2012-10-18

    Select Replace _from the _Search _menu, select _Extended _in the _Search mode box, put ',' (a comma) in the Find what: _input field, put ',\t' (comma, slash, t) in the _Replace with: input field, press Replace All… and start worrying if you have a backup of the proginal file :-)

     
  • Bob Uncle
    Bob Uncle
    2012-10-18

    Also you can open a CSV directly from the Excel open window without any converting and it will appear correctly, without the importing wizard.