Announcement

Collapse
No announcement yet.

Manuel's program for browsing large csv files

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Manuel's program for browsing large csv files

    Hi Manuel , refer to your program at https://forum.powerbasic.com/forum/u...les#post802223

    can you or someone retranslate this program to PBWin ? as I only have PBWin 10
    Thank you for your attention

  • #2
    Hi Tim,

    I'll work in a Graphic Windows version, which could be compiled with both PBWIN and PBCC. Many thanks for your interest.

    Regards,

    In the meantime maybe you can test this compiled version.
    Attached Files

    Comment


    • #3
      Originally posted by Tim Lakinir View Post
      can you or someone retranslate this program to PBWin ?
      Translating that would be rather pointless since well over 90% of that application is involved in the console display.

      You could do it a LOT more easily in PBWin 10 from scratch.

      Basically all you need to do is

      1. Parse the data file into a large array. (PARSECOUNT and PARSE are a lot easier than Manuel's cumbersome process)
      2. Use a (virtual?) Listview to display selected sections of the data.


      Last edited by Stuart McLachlan; 26 Nov 2020, 01:30 AM.

      Comment


      • #4
        I re-indented the code in Source Code. And made one notable change -
        Code:
            SCA = con.inshift '<<==== added before the SELECT CASEs
            select case ucase$(O$)
            
                'IF MID$(BIN$(INSHIFT,8),5,1)="1" THEN '<<=== replaced this
                if bit(SCA, 3) then 'If left control down '<<=== with this (no convert to string then MID$()
        in multiple places.
        I suggest change from console to TXT.WINDOW as more "do-able". Then it may be compiled in PBWin or PBCC. Also F1 takes me to MSDN instead of help in the code.

        Cheers,
        Dale

        Comment


        • #5
          Thanks Dale,

          Will study both issues.

          Stuart,

          Answering to Tim I forgot to point out that the code was intended specifically for PBCC, to handle big CSV files, meaning 10 million lines with tens of fields. That seems to me difficult and slower to handle with a single big array.

          Comment


          • #6
            I think I will just open the csv file in excel

            Comment


            • #7
              Howdy, Tim!

              Doesn't gbGrid open CSV files? I've not looked at it in a while. It's a PBWin app.

              http://www.garybeene.com/sw/gbgrid.htm

              Comment


              • #8
                Pierre has a CSV Viewer on his website.

                Comment


                • #9
                  Thank you Sirs, let me check these web links out

                  Comment


                  • #10
                    FWIW,, you may treat CSV files as either an ODBC or OLE database and read them with your favorite "view a database" tool.


                    Michael Mattias
                    Tal Systems (retired)
                    Port Washington WI USA
                    [email protected]
                    http://www.talsystems.com

                    Comment

                    Working...
                    X