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 / 178
177  |  179
Subject: 
Re: Standardized Inventory File Format?
Newsgroups: 
lugnet.db.inv
Date: 
Thu, 23 Sep 1999 14:15:14 GMT
Viewed: 
479 times
  
Steve Bliss wrote in message <37ea300b.59491442@lugnet.com>...
I suppose non-programmers could load the data file into a text editor
first, and search'n'replace all the tri-spaces with a comma.


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 be necessary to run the second replace operation multiple times, if
the program being used doesn't replace nested search strings (e.g., ',,,,'
becomes ',,' after the first pass).

Surely there's a better way.

-Gary



Message has 1 Reply:
  Re: Standardized Inventory File Format?
 
(...) 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)

Message is in Reply To:
  Re: Standardized Inventory File Format?
 
(...) 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)

25 Messages in This Thread:












Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact

This Message and its Replies on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    

Custom Search

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