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

    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
                                      • S Sascha Lefevre

                                        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 Offline
                                        L Offline
                                        Lost User
                                        wrote on last edited by
                                        #31

                                        I threw "evolution" in as an "extra"; I guess I failed to make my point. "Key Value Pair" sounds like IT-speak or something from a grocery flyer.

                                        S 1 Reply Last reply
                                        0
                                        • L Lost User

                                          I threw "evolution" in as an "extra"; I guess I failed to make my point. "Key Value Pair" sounds like IT-speak or something from a grocery flyer.

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

                                          IT-speak is alright because the only reason I'm looking for a term for it is my intention to write an Article/Tip/Trick for it :)

                                          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