Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Christopher_Campbell

  • Rank
  1. Comment, your scripting is a thing of beauty. There's nothing quite like clicking a button and watching 60,000 fields (12,000 records x 5 fields) populate themselves! Thanks to everyone who assisted, and especially Comment and Lee Smith, for all the patient assistance in making this material available.
  2. Finally, today I was able to import all the listserv records into Filemaker. Much of the work I had to do in processing the text files before import was related to the highly irregular nature of hundreds of the records (many of which had to be formatted by hand after I got as far as possible with Textwrangler and grep). Because of this unpredictability, it was not in the end feasible to end up with the three key fields — Date, From and Subject — in definitive field positions. Would it be hard for someone to show me the format for a short sample script that would parse just one of those lines,
  3. Comment, thanks for the suggestion. The trouble is that such a method is effectively non-selective, and I need to be able to pick and choose the lines that need moving.
  4. I've had some terrific support here, and now hope that someone can answer a quick TextWrangler question. I'm still cleaning up the listserv text file, and it's going very well. I've got a huge text file in which I've replaced line feeds with tabs, and displayed it so that the data is in columns. I've learned how to transpose columns when necessary, but something that I'm sure is relatively simple is eluding me in studying the User Manual. In email messages without a header, i.e. in a given line, I want to simply push all the content several columns to the right with tab characters, starting wi
  5. Comment, it's more like a tool for the guys responsible for preserving the pyramids. The estimate is that there exists something like 50 million hours of recorded audio tape, and all of it is deteriorating. Analog-to-digital converters are now of truly excellent quality, and so the race is on the preserve the most valuable of all that material. Studer decks have long been the gold standard for analog recorders — especially in the delicacy of their tape-handling — so making this material accessible will be wonderful.
  6. Lee, until last night I would say only that I was only slightly familiar with that level of searching/replacing, but I did do a quick read through the TextWrangler 3.1 user manual on grep searching, and have a close friend who is truly expert, so I would be entirely willing to go in that direction if that makes the most sense.
  7. Comment, the work of your script is simply lovely, and gives me hope that the many former users of the Studer list will soon have an extremely useful tool. As for your suggestion about doing more pre-processing, could I please ask you to be more specific? Once I had all seven text segments sequenced in TextWrangler, I found I had some 22 millions chars, 3.4 million lines and 10,623 messages of consistent inconsistency, so it was far from clear to me how I could clarify the structure without damaging or losing any information! Thanks so much.
  8. As the Studer archive files span nearly ten years, the format changes slightly from chunk to chunk. However, I've saved a sample from one so that anyone interested can see one of the original formats. It's wonderful that so many of you experienced users take note of these posts so quickly! Lee, the Studer forum is open only to accepted members, but is located here: http://tech.groups.yahoo.com/group/STUDER/ Studer_listserv_text_sample.txt.zip
  9. Hello all, I have used Filemaker for many years, but only in fairly rudimentary ways. As one of a group of people doing audio preservation work, I recently downloaded the listserv archives for Studer open-reel tape recorders and found that they are extremely difficult to use as huge, continuous blocks of text. Last night I spent a few hours massaging and cleaning up the text a bit in TextWrangler, and have now imported the seven archived text files into Filemaker in the most basic mode, where Filemaker supplies simple numbered fields. The basic structure of the listserve is intact, and th
  10. Hi Jens, I had considered that option, but the trouble is that not all records in the database get "worklist" serial numbers. Some records are of prints made for clients, and some of my work doesn't turn out well enough to get a number and stand as part of my exhibitable corpus. It is precisely because I can't simply look at the prior record, or simply increment serial numbers, that it would be useful to display the max value for the field.
  11. DukeS, I'm afraid your advice is far too cryptic for me to be able to make use of it at all. My database is a simple flat file with about one hundred fields. The field for which I would like to find a maximum is a text field, "Worklist number," with a form that I specified above. I have no related fields, no repeating fields. A quick scan of the index of Lane, Bowers et al Using Filemaker 7 shows no entries for "Cartesian" (I assume that's what you meant?). Could I please ask that you be quite specific in laying out exactly what fields are necessary to get from my simple number to the Max calc
  12. I keep a "worklist" of final photographic prints in Filemaker and assign each work a number in the form "class.year.sequence.frame," such that a given work might look like "3.2006.021.9774" and I would like to have a calculation field display the prior maximum value. I know that because I've used periods as separators, the value will display as 3.20060219774, which is a little awkward, but still usable. However, when I created a calculation field called "Worklist_max" and defined it as: Max (Worklist number), it only displays a value in records where I have already assigned a worklist number.
  13. Well, when I joined the forum this morning, I listed my experience level as "Intermediate" because I've been using Filemaker for something like 20 years. However, I have to confess that I'm not a very sophisticated user, and have no idea what a table, or a portal, even is, much less what it's capable of doing. I have recently purchased a copy of the Lane, Bowers et al Using Filemaker 7, so I guess I have some homework to do. Are there any particular resources toward which you would point me so as to be able to execute your suggestions? Thanks very much.
  14. I am an artist and professional photographer who uses Filemaker to keep track of the editing and printing decisions behind my final prints. In the record for a given image, I have a sequence of 10 fields in which I log the major editing moves I make in Photoshop, and they contain entries such as: "Contrast layer, overlay blend, 20% opacity." Because the editing sequence is unique for each image, it doesn't make sense to organize these as Drop-down lists. At the moment, I have a text field in my entry layout in which I have the 20 most used editing moves available for selective cutting and past
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.