You want to take a look at sed and/or awk. awk is good at extracting, say, one column of text from a text file. sed (for Stream EDitor") is better for making changes to the text after it's been extracted by awk. For example, to print the first column of text in the file "t.txt" use: awk '{print $1}' t.txt. (note the single quotes).
If you're on a windows box you can find them in the free Unix toolset at: http://www.cygwin.com/. There's a bunch of useful tools in Cygwin, so it's worth checking it out. There's a lot more than I can explain here, but if you get the chance take a look at "Unix Power Tools", an O'Reilly book. It gives you a lot of tricks that'll save a lot of time. For sed and awk, check out "sed & awk", also from O'Reilly. You know, If anyone wants, I can start posting tips and tricks that I've picked up... I'd love to hear about the time savers other people have come up with. Jeff Polaski Manager, Web Services Research & Graduate Studies University California, Irvine -----Original Message----- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 11:09 AM 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists