Menu

Comma Separated Values, Color each column

2009-02-23
2012-11-13
  • Robert Golden

    Robert Golden - 2009-02-23

    This might be out of the spectrum for Notpad++. Basically I've had to edit tons of txt documents which are actually Comma Separated Values. For example the txt document will look like this. (example only, not real check numbers...)

    "BEGDOC#","ENDDOC#","FIRM","INVOICE#","PAIDFROM","CHECK#"
    "DDI00013104","DDI00013104","","","DYNAMAKE GRAPHICS GROUP","107742"
    "DDI00013105","DDI00013108","PIT PRINTING","31520","",""
    "DDI00013109","DDI00013109","","","STATE MUTUAL","253197"

    All of the text is black. I would love it if I can get each column a specific color that matches the header. This would help elminiate human error. I've been able to color the commas, headers, and numbers.

    Is what I am trying to do in the spectrum of Notpad++. If so please assist.

     
    • Alexander Iljin

      Alexander Iljin - 2009-02-23

      It is possible to implement by creating a lexer plugin, but that is a far as I can assist you in this topic.

       
    • Jan Schreiber

      Jan Schreiber - 2009-02-23

      Not that it's any business of mine, but why don't you use a spreadsheet application for this kind of thing? I'm a huge fan of N++, but nothing beats a spreadsheet program when it comes to CSV editing IMO. Customizable colum width, etc. Just my 0.02 $.

       
  • cimenta

    cimenta - 2010-03-14

    @janschreiber because N++ is smaller, quicker, faster … I would love to have CSV support in N++ R.

     
  • cchris

    cchris - 2010-03-14

    You can ask for this on IdeaTorrent. If there are really many requests, someone may develop a plugin for basic spreadsheet support. But this seems to stray way off from the purpose of a text editor indeed.

    CChris

     
  • Fool4UAnyway

    Fool4UAnyway - 2010-03-14
     
  • cimenta

    cimenta - 2010-03-18

    @cchris: great idea. I did not know that anything like that exists. I submitted it.

     
  • cimenta

    cimenta - 2010-03-18

    @fool4uanyway  thank you for pointing that out. It is just great product. I recommend CSVed to anybody. I would love to have csv support within notepad++ though :-)