Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Looking for a term

Looking for a term

Scheduled Pinned Locked Moved The Lounge
questionlounge
34 Posts 19 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Sascha Lefevre

    In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

    ### header
    001 value1
    002 value2
    010 value3
    300 value4

    header of next record

    (etc)

    As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

    If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

    P Offline
    P Offline
    PIEBALDconsult
    wrote on last edited by
    #11

    Are you sure that's not an INI file? :suss:

    S V 2 Replies Last reply
    0
    • P PIEBALDconsult

      Are you sure that's not an INI file? :suss:

      S Offline
      S Offline
      Sascha Lefevre
      wrote on last edited by
      #12

      Well.. they initialize the madness that will befall you when actually dealing with their semantic content.. :sigh:

      If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

      1 Reply Last reply
      0
      • S Sascha Lefevre

        In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

        ### header
        001 value1
        002 value2
        010 value3
        300 value4

        header of next record

        (etc)

        As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

        If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

        D Offline
        D Offline
        Dr Walt Fair PE
        wrote on last edited by
        #13

        Unless I{m missing something, it looks like columnar data to me.

        CQ de W5ALT

        Walt Fair, Jr., P. E. Comport Computing Specializing in Technical Engineering Software

        S 1 Reply Last reply
        0
        • S Sascha Lefevre

          In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

          ### header
          001 value1
          002 value2
          010 value3
          300 value4

          header of next record

          (etc)

          As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

          If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

          K Offline
          K Offline
          KarstenK
          wrote on last edited by
          #14

          Be sure to implement some robust error handling. :thumbsup: Remember: shit happens :rolleyes:

          Press F1 for help or google it. Greetings from Germany

          S 1 Reply Last reply
          0
          • S Sascha Lefevre

            In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

            ### header
            001 value1
            002 value2
            010 value3
            300 value4

            header of next record

            (etc)

            As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

            If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

            M Offline
            M Offline
            Marco Bertschi
            wrote on last edited by
            #15

            It comes close to an ini file, but I'd go with Walt's columnar data term.

            "A property doesn't have to be a Property to be a property." - PIEBALDConsult

            1 Reply Last reply
            0
            • D Dr Walt Fair PE

              Unless I{m missing something, it looks like columnar data to me.

              CQ de W5ALT

              Walt Fair, Jr., P. E. Comport Computing Specializing in Technical Engineering Software

              S Offline
              S Offline
              Sascha Lefevre
              wrote on last edited by
              #16

              Sounds good, though I'm a bit worried people might think it has anything to do with columnar databases... Please take a look - can you confirm the term "columnar" for this kind of file/record layout?:

              ### 00043nM2.01000024 h
              001 0000000913
              003 20150612
              004 20100526
              030 a|1ibr|a|||17
              076eTourismus
              100 Finger-Benoit, Claus
              104aGayler, Brigitte
              331aAnimation im Urlaub
              335aHandbuch fr Planer und Praktiker
              359 Claus Finger ; Brigitte Gayler
              403 3., vollst. berarb. u. aktualis. Aufl.
              410 Mnchen [u. a.]
              412 Oldenbourg
              425a2003
              433 IX, 340 S.
              434 Ill.
              451bLehr- und Handbcher zu Tourismus, Verkehr und Freizeit
              527z636517721 Digitalisierte Ausg. --->Animation im Urlaub
              540aISBN 978-3-486-27363-2 Pb.
              568 03N052763
              655ehttp://www.gbv.de/dms/hbz/toc/ht013645014.pdf
              655ehttp://d-nb.info/965931528/04
              700 T::FIN
              750cDas Standardwerk zur Urlaubs-Animation in dritter Auflage! Es ist ebenso ein Zeitdokument des modernen Tourismus, wie eine Handlungsanweisung zum animativen Urlaub fr Tourismusunternehmen, Studierende der Touristikstudieng„nge, G„stebetreuer und Urlauber. Aus dem Inhalt: Einleitung. Grundlagen der Animation. Urlaubserwartungen und Urlaubsaktivit„ten. Inhaltliche Bereiche der Animation im Urlaub. Die Person - der Animateur, die Animateurin. Grundlagen und Prinzipien der Animation. Systembeschreibungen - Beispiele realisierter Animation.
              902 Animation
              902 Urlaub
              902 Handbuch

              00044nM2.01000024 l

              001 0000000913
              003 20150612
              004 20100526
              012 0000000913
              100 T 76
              105 Bibliothek
              120 00001465

              00045nM2.01000024 h

              001 0000000915
              003 20150612
              004 20100526
              030 a|1ibr|a|||17
              076eTourismus
              100 Schulz, Axel
              331aVerkehrstr„ger im Tourismus
              335aLuftverkehr, Bahnverkehr, Straenverkehr, Schiffsverkehr
              359 von Axel Schulz
              403 1. Auflage
              410 Mnchen
              412 Oldenbourg
              425a2009
              433 X, 342 S.
              434 Ill., graph. Darst.
              451bLehr- und Handbcher zu Tourismus, Verkehr und Freizeit
              501 Literaturverz. S. [321] - 334
              540aISBN 978-3-486-58876-7 Gb. : 34,80 EUR
              568 08N290333
              655ehttp://deposit.d-nb.de/cgi-bin/dokserv?id=3131366&prov=M&dok_var=1&dok_ext=htm
              655ehttp://www.gbv.de/dms/zbw/571624782.pdf
              655ehttp://d-nb.info/989417263/04
              700 T::SCHUL
              750cZiel des Lehrbuches ist es, einen umfassenden šberblick aller Arten von Verkehrstr„ger (Flug-, Bahn-, Straáen- und Schiffsverkehr) und deren Bedeutung im Tourismus zu geben. Hierzu wurde ein Referenzmodell fr alle Verkehrstr„ger entwickelt, welches aus den Grundelementen Mar

              M 1 Reply Last reply
              0
              • K KarstenK

                Be sure to implement some robust error handling. :thumbsup: Remember: shit happens :rolleyes:

                Press F1 for help or google it. Greetings from Germany

                S Offline
                S Offline
                Sascha Lefevre
                wrote on last edited by
                #17

                Yeah.. though I wish that'd be the major challenge here :laugh:

                If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                1 Reply Last reply
                0
                • Sander RosselS Sander Rossel

                  Key-Value pairs? Dictionary? Hashtable? Associative array? Or am I missing something?

                  Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

                  Simplicity is prerequisite for reliability. — Edsger W. Dijkstra

                  Regards, Sander

                  B Offline
                  B Offline
                  BillWoodruff
                  wrote on last edited by
                  #18

                  key-value pair data file

                  «In art as in science there is no delight without the detail ... Let me repeat that unless these are thoroughly understood and remembered, all “general ideas” (so easily acquired, so profitably resold) must necessarily remain but worn passports allowing their bearers short cuts from one area of ignorance to another.» Vladimir Nabokov, commentary on translation of “Eugene Onegin.”

                  1 Reply Last reply
                  0
                  • S Sascha Lefevre

                    In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

                    ### header
                    001 value1
                    002 value2
                    010 value3
                    300 value4

                    header of next record

                    (etc)

                    As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

                    If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                    G Offline
                    G Offline
                    Gennady Oster
                    wrote on last edited by
                    #19

                    Distributed recordset ?

                    My English is permanently under construction. Be patient !!

                    1 Reply Last reply
                    0
                    • S Sascha Lefevre

                      Sounds good, though I'm a bit worried people might think it has anything to do with columnar databases... Please take a look - can you confirm the term "columnar" for this kind of file/record layout?:

                      ### 00043nM2.01000024 h
                      001 0000000913
                      003 20150612
                      004 20100526
                      030 a|1ibr|a|||17
                      076eTourismus
                      100 Finger-Benoit, Claus
                      104aGayler, Brigitte
                      331aAnimation im Urlaub
                      335aHandbuch fr Planer und Praktiker
                      359 Claus Finger ; Brigitte Gayler
                      403 3., vollst. berarb. u. aktualis. Aufl.
                      410 Mnchen [u. a.]
                      412 Oldenbourg
                      425a2003
                      433 IX, 340 S.
                      434 Ill.
                      451bLehr- und Handbcher zu Tourismus, Verkehr und Freizeit
                      527z636517721 Digitalisierte Ausg. --->Animation im Urlaub
                      540aISBN 978-3-486-27363-2 Pb.
                      568 03N052763
                      655ehttp://www.gbv.de/dms/hbz/toc/ht013645014.pdf
                      655ehttp://d-nb.info/965931528/04
                      700 T::FIN
                      750cDas Standardwerk zur Urlaubs-Animation in dritter Auflage! Es ist ebenso ein Zeitdokument des modernen Tourismus, wie eine Handlungsanweisung zum animativen Urlaub fr Tourismusunternehmen, Studierende der Touristikstudieng„nge, G„stebetreuer und Urlauber. Aus dem Inhalt: Einleitung. Grundlagen der Animation. Urlaubserwartungen und Urlaubsaktivit„ten. Inhaltliche Bereiche der Animation im Urlaub. Die Person - der Animateur, die Animateurin. Grundlagen und Prinzipien der Animation. Systembeschreibungen - Beispiele realisierter Animation.
                      902 Animation
                      902 Urlaub
                      902 Handbuch

                      00044nM2.01000024 l

                      001 0000000913
                      003 20150612
                      004 20100526
                      012 0000000913
                      100 T 76
                      105 Bibliothek
                      120 00001465

                      00045nM2.01000024 h

                      001 0000000915
                      003 20150612
                      004 20100526
                      030 a|1ibr|a|||17
                      076eTourismus
                      100 Schulz, Axel
                      331aVerkehrstr„ger im Tourismus
                      335aLuftverkehr, Bahnverkehr, Straenverkehr, Schiffsverkehr
                      359 von Axel Schulz
                      403 1. Auflage
                      410 Mnchen
                      412 Oldenbourg
                      425a2009
                      433 X, 342 S.
                      434 Ill., graph. Darst.
                      451bLehr- und Handbcher zu Tourismus, Verkehr und Freizeit
                      501 Literaturverz. S. [321] - 334
                      540aISBN 978-3-486-58876-7 Gb. : 34,80 EUR
                      568 08N290333
                      655ehttp://deposit.d-nb.de/cgi-bin/dokserv?id=3131366&prov=M&dok_var=1&dok_ext=htm
                      655ehttp://www.gbv.de/dms/zbw/571624782.pdf
                      655ehttp://d-nb.info/989417263/04
                      700 T::SCHUL
                      750cZiel des Lehrbuches ist es, einen umfassenden šberblick aller Arten von Verkehrstr„ger (Flug-, Bahn-, Straáen- und Schiffsverkehr) und deren Bedeutung im Tourismus zu geben. Hierzu wurde ein Referenzmodell fr alle Verkehrstr„ger entwickelt, welches aus den Grundelementen Mar

                      M Offline
                      M Offline
                      milo xml
                      wrote on last edited by
                      #20

                      I'd say yes, column delimited. You have three columns. Number, space or lower case letter, then the data. I'm assuming you have text wrap on in the case of line 750. Just odd that they didn't delimit it better.

                      S E 2 Replies Last reply
                      0
                      • P PIEBALDconsult

                        Are you sure that's not an INI file? :suss:

                        V Offline
                        V Offline
                        Vark111
                        wrote on last edited by
                        #21

                        This is the closest that comes to my mind. INI format is exactly what you've got there, except yours is missing the = sign between the key and value. You have section headers followed by a bunch of key value pairs that only apply to that section. Now you may not be using for configuration data, which is what INI format files are typically used for, but I don't think that's a requirement of the format per se.

                        1 Reply Last reply
                        0
                        • S Sascha Lefevre

                          In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

                          ### header
                          001 value1
                          002 value2
                          010 value3
                          300 value4

                          header of next record

                          (etc)

                          As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

                          If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                          K Offline
                          K Offline
                          Kirk 10389821
                          wrote on last edited by
                          #22

                          This reminds me of an EDI file. I assume it cannot handle a MULTI-LINE value. I assume only ONE value per line Since it has multiple record types inside one file, I agree that it looks like an INI file without equal signs, or [] sections. I would start by calling a single file with ONE set of values: A Space Delimited KEY VALUE file. But you could simplify it by calling it a Key Value file. The fact that multiple headers can exist, implies some level or hierarchy. So, I get to: Hierarchical Key Value File (Sounds nice and formal) or a Multi-Section Key Value File Organized Key Value File Multi Key Value File EDIType Key Value File Hopefully that gets you started Now are you going to design an event driven parser. Where each time it finds a header, it calls an event to get it parsed until the next hearder?

                          S 1 Reply Last reply
                          0
                          • M milo xml

                            I'd say yes, column delimited. You have three columns. Number, space or lower case letter, then the data. I'm assuming you have text wrap on in the case of line 750. Just odd that they didn't delimit it better.

                            S Offline
                            S Offline
                            Sascha Lefevre
                            wrote on last edited by
                            #23

                            milo-xml wrote:

                            Just odd that they didn't delimit it better.

                            The format originates from the seventies... X|

                            If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                            1 Reply Last reply
                            0
                            • K Kirk 10389821

                              This reminds me of an EDI file. I assume it cannot handle a MULTI-LINE value. I assume only ONE value per line Since it has multiple record types inside one file, I agree that it looks like an INI file without equal signs, or [] sections. I would start by calling a single file with ONE set of values: A Space Delimited KEY VALUE file. But you could simplify it by calling it a Key Value file. The fact that multiple headers can exist, implies some level or hierarchy. So, I get to: Hierarchical Key Value File (Sounds nice and formal) or a Multi-Section Key Value File Organized Key Value File Multi Key Value File EDIType Key Value File Hopefully that gets you started Now are you going to design an event driven parser. Where each time it finds a header, it calls an event to get it parsed until the next hearder?

                              S Offline
                              S Offline
                              Sascha Lefevre
                              wrote on last edited by
                              #24

                              Yeah, I think I'll go with Key-Value file :)

                              Kirk 10389821 wrote:

                              Now are you going to design an event driven parser. Where each time it finds a header, it calls an event to get it parsed until the next hearder?

                              I'll split it into Key-Value pairs first without caring for the values and then pass the list of Key-Value pairs to the next processing stage. I don't need events there but if someone who wants to use my reader-code from the Tip/Trick I'm going to write needs events he'll still be able to implement them on the list of Key-Value pairs ;)

                              If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                              1 Reply Last reply
                              0
                              • S Sascha Lefevre

                                In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

                                ### header
                                001 value1
                                002 value2
                                010 value3
                                300 value4

                                header of next record

                                (etc)

                                As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

                                If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                                L Offline
                                L Offline
                                Lost User
                                wrote on last edited by
                                #25

                                Records in a "Fielded" text file: Fielded text - Wikipedia, the free encyclopedia[^] (Your "key-value" pairs could easily evolve into something more comprehensive; then you're stuck with a misleading name).

                                S 1 Reply Last reply
                                0
                                • L Lost User

                                  Records in a "Fielded" text file: Fielded text - Wikipedia, the free encyclopedia[^] (Your "key-value" pairs could easily evolve into something more comprehensive; then you're stuck with a misleading name).

                                  S Offline
                                  S Offline
                                  Sascha Lefevre
                                  wrote on last edited by
                                  #26

                                  I appreciate your intent, Gerry, but I'm certain that it won't evolve: It's not my own creation, it's a standard originating from the seventies and the basic structure hasn't changed since ;)

                                  If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                                  L 1 Reply Last reply
                                  0
                                  • S Sascha Lefevre

                                    In the domain of my current project I'm dealing with exchange formats where records are saved with key-value pairs each in a separate line:

                                    ### header
                                    001 value1
                                    002 value2
                                    010 value3
                                    300 value4

                                    header of next record

                                    (etc)

                                    As I'm planning on writing a Tip/Trick on a general purpose reader for that kind of format I'm wondering if there is an existing term for this - something like "line separated values"? thanks, Sascha

                                    If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                                    W Offline
                                    W Offline
                                    wizardzz
                                    wrote on last edited by
                                    #27

                                    what do mean by exchange formats? fixed format, as in cobol comes to mind, or space delimited, or series data?

                                    S 1 Reply Last reply
                                    0
                                    • W wizardzz

                                      what do mean by exchange formats? fixed format, as in cobol comes to mind, or space delimited, or series data?

                                      S Offline
                                      S Offline
                                      Sascha Lefevre
                                      wrote on last edited by
                                      #28

                                      It's newline-delimited. I'm just wondering if there's a term for it, like CSV for comma-separated. What is your notion of series data?

                                      If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                                      W 1 Reply Last reply
                                      0
                                      • S Sascha Lefevre

                                        It's newline-delimited. I'm just wondering if there's a term for it, like CSV for comma-separated. What is your notion of series data?

                                        If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                                        W Offline
                                        W Offline
                                        wizardzz
                                        wrote on last edited by
                                        #29

                                        Isn't CSV technically newline-delimited as well as comma separated? I guess series data, I was thinking if it's ordered like time series, but none of the values are datetime. Not sure if that makes sense. Order Number Value 10 11.2 11 16.5 12 18.5

                                        S 1 Reply Last reply
                                        0
                                        • W wizardzz

                                          Isn't CSV technically newline-delimited as well as comma separated? I guess series data, I was thinking if it's ordered like time series, but none of the values are datetime. Not sure if that makes sense. Order Number Value 10 11.2 11 16.5 12 18.5

                                          S Offline
                                          S Offline
                                          Sascha Lefevre
                                          wrote on last edited by
                                          #30

                                          wizardzz wrote:

                                          Isn't CSV technically newline-delimited as well as comma separated?

                                          Sure. Then "my" format would be "empty-line-delimited and newline-separated" :)

                                          wizardzz wrote:

                                          I was thinking if it's ordered like time series, but none of the values are datetime.

                                          No, that's not the right term for it then. I think I'll go with "something key-value something" ;)

                                          If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups