To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.db.invOpen lugnet.db.inv in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Database / Set Inventories / 173
    Re: Standardized Inventory File Format? —Robert Munafo
   (...) I solve that problem by using *3 or more spaces* as the delimiter. If you want to delimit the next field, you must always use at least 3 spaces in a row. This allows things like color names to include spaces and allows for a little human error (...) (25 years ago, 22-Sep-99, to lugnet.db.inv)
   
        Re: Standardized Inventory File Format? —John Cromer
     (...) This (...) Let's do it. 3 spaces between fields: count DATfilename Color Optional description Now, not being a CAD nut, where would I find the DATfilenames? And what do we put for parts without DATfilenames? as evah, John C. (25 years ago, 22-Sep-99, to lugnet.db.inv)
    
         Re: Standardized Inventory File Format? —Gary Williams
      John Cromer wrote in message ... (...) I'd start at (URL) and try printing the Word version of the parts catalog. M$IE garbled the images and then crashed badly on me when I tried viewing the HTML version from the zip file. Forced a reboot (I made (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)
    
         Re: Standardized Inventory File Format? —Steve Bliss
      (...) Look at (URL) The LDraw numbers are included there, and there are links to Technica and Lutz Uhlman's parts list. Steve (25 years ago, 23-Sep-99, to lugnet.db.inv)
    
         Re: Standardized Inventory File Format? —Robert Munafo
     (...) My parts database format is human-readable and well-suited to use by programs as well as humans, and solves your problem quite well. My inventory scripts use it. Look at: (URL) are some sample entries: ld2412, mr0055 Name: 1 x 2 tile with (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)
   
        Re: Standardized Inventory File Format? —Steve Bliss
   (...) Are there many programs that support multi-character delimiters in their import function? I'm fairly certain Excel and MS-Access do not. The point of making a standard format is to make the data more accessible to everyone. Not just coders. I (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)
   
        Re: Standardized Inventory File Format? —Gary Williams
      Steve Bliss wrote in message <37ea300b.59491442@l...et.com>... (...) People may end up with multiple commas if there happens to be a gap of six or more spaces, then. Of course after replacing ' ' with ',', they could replace ',,' with ','. It might (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)
    
         Re: Standardized Inventory File Format? —Robert Munafo
     (...) Yes -- the way to do that type of transformation in a single operation is to replace the grep expression / +/ with /,/. Of course, if you don't have grep replace in your text editor, get a real text editor (-: Just kidding! Every major OS can (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)
    
         Re: Standardized Inventory File Format? —Steve Bliss
      (...) But not every major user wants to run Perl. Steve (25 years ago, 24-Sep-99, to lugnet.db.inv)
     
          Re: Standardized Inventory File Format? —Gary Williams
       Steve Bliss wrote in message <37ebce49.24708031@l...et.com>... (...) will do (...) I could easily write an inventory file formatting program to perform this task. It would give the user full control over how he/she wanted a file to be formatted, and (...) (25 years ago, 24-Sep-99, to lugnet.db.inv)
     
          Re: Standardized Inventory File Format? —Larry Pieniazek
       (...) But any major dude with half a heart surely will tell you, my friend... - ABSie Dan (well. it seemed funny at the time, but I still have coaster hair so what do I know. Could be all the mosquitoes I inhaled while screaming.) -- Larry Pieniazek (...) (25 years ago, 25-Sep-99, to lugnet.db.inv, lugnet.off-topic.fun)
      
           Re: Standardized Inventory File Format? —Tony Priestman
        In article <37EC3B39.70B577CA@v...ager.net>, Larry Pieniazek <lar@voyager.net> writes (...) Just *how* do you do that? A third lung? Breathing through your ears? (25 years ago, 25-Sep-99, to lugnet.off-topic.fun)
       
            Re: Standardized Inventory File Format? —Larry Pieniazek
        OK, technically, it wasn't WHILE I was screaming in a strict time sense. It was while gulping air for the NEXT scream. It IS possible to make sounds while inhaling, but not screams. (...) (25 years ago, 25-Sep-99, to lugnet.off-topic.fun)
      
           Re: Standardized Inventory File Format? —Steve Bliss
       (...) Huh? (...) Gotta watch out for those Minnesota songbirds. Steve (25 years ago, 27-Sep-99, to lugnet.off-topic.fun)
     
          Re: Standardized Inventory File Format? —Robert Munafo
      (...) Are you speaking for yourself? If so, explain why you'd rather use some other programming language system in place of Perl. Remember, we're trying to design a standard that will work for lots of people who aren't here to represent themselves. (...) (25 years ago, 27-Sep-99, to lugnet.db.inv)
     
          Re: Standardized Inventory File Format? —Steve Bliss
      (...) I wasn't speaking for myself--I could learn Perl, if I wanted. I haven't needed to yet, and haven't felt like making the time--other activities have higher priorities. I was thinking of people who aren't programmers, don't know how to program, (...) (25 years ago, 28-Sep-99, to lugnet.db.inv)
    
         Re: Standardized Inventory File Format? —Ran Talbott
     (...) So will: sed "s/ +/,/g" <spaces.txt >comma.txt Which will run on any machine (even an 8088 laptop) that has a DOS- or *nix-style command line. And sed is small enough that most people who might balk at Perl wouldn't mind installing it, even as (...) (25 years ago, 22-May-00, to lugnet.db.inv)
   
        Re: Standardized Inventory File Format? —Robert Munafo
     (...) It doesn't do much good if the use of commas makes it so the columns don't line up. You want these inventory files to be easy to read by humans, and that means the columns need to line up! If we use commas as delimeters, we also need to add (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)
   
        Re: Standardized Inventory File Format? —Ardjan Besse
   Op een zekere dag, te weten Thu, 23 Sep 1999 13:54:23 GMT, klom blisses@worldnet.att.net (Steve Bliss) in het toetsenbord en schreef ons: (...) Excel (97) at least can import multi-char delimeters. In the import-window, you can choose the delimeter (...) (25 years ago, 25-Sep-99, to lugnet.db.inv)
 

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR