Well you could parse files like that with CF, or just about any other language. Excel and Access can be used to do some of this, not sure about getting just 1 or 2 columns from separate files, then joining. Also you could do it with a SQL Server and write some join tables or views. I would think there would be many many ways to do it.
Tim Heald ACP/CCFD :) Application Development www.schoollink.net > -----Original Message----- > From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 2:09 PM > To: CF-Talk > Subject: RE: At my new job > > > I have a similar question. (I'm about to date myself now.) Many > years ago > I worked on a Wang VS system. There was a utility called CREATE > which would > allow you to take just about any data file or files and pull specific > columns and rows from it to create a new file. For example, if I had 2 > files (A and B) I could say: > > Start with file A, column 5 for a length of 4, but only for the first 10 > rows. Add to the end of that row from file B, starting at position 19, > length of 12, for the first 10 rows. Then add the characters "ABC" at the > end of the row for 10 rows. Now start on row 11, etc. > > All of this was in a great utility that was easy to use. Is > there anything > out there today which would do a similar task? > > Athelene Gieseman > [EMAIL PROTECTED] > > -----Original Message----- > From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 12:50 PM > To: CF-Talk > Subject: FW: At my new job > > I'm fan of UltraEdit. It has a "column mode" which can save a lot > of typing. > Sometime I use XEmacs, another great editor, but I don't use it > as much as > I use UltraEdit. I've used it to edit some pretty big files, but It loads > the whole file into memory, though. > > It sounds like you have a very specific task in mind for your editor. > Depending on what you want to do, you might be able to write a > Sed|Awk|Perl|Python|etc... script to do what you want. > > While we're on the topic of text editing, I also Python to do a lot of > repetitive text generation. For example I can feed a table, a list of > columns, and their type and size into a Python script and get > back an insert > and update statements, formatted like I want and with trim() and > isdefined() > where I want it. It's so much easier than doing it all by hand for > data-entry type apps. > > > Jeff Polaski > Manager, Web Services > Research & Graduate Studies > University California, Irvine > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 8:00 AM > To: CF-Talk > Subject: At my new job > > > Well i'm now settled in at my new job :) WHOO HOO!! > After my boss tried to have me arrested for "HACKING" his servers and > all that was fun > my old boss was a threatster :) > > > OK OK now to the point > i need to find a win32 textbased editor that does not have to load the > whole damn file into memory first. > I remember it being on here before so i'm curious. > > Any help would be appreciated! > > > > Bill Wheatley > Senior Database Developer > Ediets.com > Macromedia Certified Coldfusion Developer > 954.360.9022 X159 > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
