Jump to content

Mark Turner

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mark Turner

  • Rank
  • Birthday 04/08/1954
  1. Mark Turner

    Find Records where several fields match

    Thanks, Doug. I tried pasting your version in and got the error message "There are too many separators in this function." Then I noticed a missing ) after the last field, put it in, and it works as expected. Now a search in the calculation field for "match" returns all records where the names are the same and a search for "variance" returns those with a difference.
  2. Using FM Pro 6. Is there a way to perform a find that returns all records where the contents of several fields are the same? My attempt using a calculation field with an IF statement did not work as expected. Here's the calculation: If( (PublicationLatin = OR_WA_Plants::ScientificName = FNA Name = Hitchcock Name = Jepson Name = Oregon Flora Name = WA Checklist Name = CalFlora Name = e_Flora BC Name), "match", "variance") I should get "match" in my calc field (result set to text) when all the referenced fields are the same, "variance" when they're different. Those words show up, but when I page through my found records it's obvious that something isn't working. I get "variance" when the text is the same. I also get "match" when the fields are not the same (some are blank in some records). Thank you, -- Mark Turner
  3. Mark Turner

    Export formatted text from calculation

    Thanks, Vaughn and Bob. It's not the answer I wanted to read, but expected. I'll try Bob's rtf trick for the fields that have consistent formatting, but am resigned to manually redoing the individual word formatting after exporting to the word processor. -- Mark Turner
  4. Two issues: 1) I want to retain text formatting (underlining) on individual words and phrases applied in a text field when that field is concatenated with others in a calculated text field. Is there a way to do it in FM6? 2) I want to retain that word-level text formatting when I export the calculated text field. The exported text will be opened in MSWord. I picked up in another thread, "Output report as a file??" that it's possible to insert RTF formatting codes to format each record. I haven't tried it yet, but the example looked pretty straight-forward. But I don't know that the RTF code technique will help with the word-level formatting. In case it makes any difference, the project is a manuscript for a book, with 1220 records to be formatted and exported. Redoing the text formatting in MSWord will be extremely tedious if I have to do it that way. The publisher has very specific requirements for the way the MSWord manuscript is formatted and delivered. I've gotten everything but the individual word formatting working by creating a big text calculation field that concatenates the contents of several other fields with formatting codes. I read in another thread that FM7 doesn't strip text formatting in calculation fields, but this isn't the time (while overdue on a deadline) to migrate to the new version. Thanks for your help. -- Mark Turner
  5. Mark Turner

    Calculation on multiple related records

    Espringer: Thanks for your response. The "SymbolKey" field is a shorthand for the botanical name for a native plant. It's the common link across several databases holding the source information for a book, and comes from the USDA PLANTS database at <http://plants.usda.gov>. I know my file names look a little wierd, but I'm the only one who will ever use them and they're quite meaningful to me. Once I get this working with the WTU data, I need to replicate the process with at least three other source databases with similar, but not necessarily identical, structures. The goal of this process is to have one record per plant in OR_WA_County_WTU that shows in which counties in WA or OR it can be found. The data will get exported, one record at a time, and run through a GIS system to generate one map per plant. The GIS program expects one field per county with a numerical value indicating whether to shade the area or leave it blank. The WTUCountyWorking database came from an outside source and is structured with one record per instance per plant. If AQFO (Aquilegia formosa) is found in 33 counties, then there are 33 records for that plant. There may be more than one record with the same value in the "county" field because the records actually represent dried plant specimens in an herbarium collection. In the original file, there are a large number of additional fields that show things like who collected the plant, where it was found, habitat where found, date collected, etc. I've added the "SymbolKey" field to my working copy of this database so it will link with the other files I'm using. The original database is accessible on-line at <http://herbarium.botany.washington.edu/FMPro?-db=VP%20Inventory&-lay=web&-format=vpsearch.htm&-view>. My working copy is about 8 MB, too big to attach. Hopefully this has clarified the nature of the task. -- Mark Turner OR_WA_County_WTU.zip
  6. I'm trying to summarize the data from a multi-record per relationship file into a single field in a destination file. I'm using a calculation field in the destination file, but it only finds data in the first related record. WTUCountyWorking.fp5 has these fields (plus others not used in the calculation): SymbolKey (used to define relationship) State County Data in the State field is either "Washington" or "Oregon" and the County field contains the name of one of the 75 counties in the two states. There are anywhere from one to 40 records which have the same value in SymbolKey and more than 16,000 records in the file, which came from an outside source. OR_WA_County_WTU.fp5 has these fields: SymbolKey (used to define relationship) 75 individual County fields, of the form WA_Adams, WA_Benton, OR_Baker, etc. The county fields are all calculated, using the following formula: If( (WTUCountyWorking::State="Washington" and WTUCountyWorking::County="Adams") , 1 , 0 ) The goal here is to end up with a "1" in the county field if at least one record in the related database has the county name in the "County" field. Is there a way to have the calculation look at all related records, or is there another technique I should be using?

Important Information

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