Re: WORD doc info into FMP?

Bill, your solution has nothing to do with search and replace, or Excel but neither did option number 4 in my list, which was to import into a single record and then use position to populate other fields, as you suggested. I admit I did suggest getting rid of the carriage returns first, primarily because using the "¶" character occasionally causes hysterics for Windows users.

I certainly acknowledged that you made his life easier by actually providing the necessary base calculation, but it was still the same method, and the method absolutely requires that all headings in all records have identical spelling. None of my suggestions required scripts, and I don't think the original poster actually meant scripts, but rather calculations, though that is simply a guess on my part. My self-exposed flaw was my over-reaction to you using the words "considerably easier" in reference to the method, when I included the same method as you, but not the detailed instructions on how to do it.

Kent


Bill Marriott wrote:
Uh, Kent,

How does my recommendation have anything to do with search and replace or macros in Word or Excel? It doesn't. You just specify to import a folder of text files and you're done. (If for some reason the files are in .doc format instead of .txt, Word includes a batch conversion command.)

And, does not having an actual calculation you can just drop into your FileMaker file, one that requires just a simple edit for each header, (1) not a "variation" but an actual solution and (2) also make it much easier?

The original poster was thinking of writing scripts and contemplating having the data re-entered by hand as an alternative. He wrote, "I suspect that the undertaking is too complex, given the variations in the information from entry to entry...."

I think the task is relatively easy to be honest. The calculation I posted will always work to extract the information following a heading that starts at the beginning of a line, whatever the format of information that follows it.

Sorry, I can't say that creating an XML document and schema, or the other elaborate and time-consuming processes you suggested were particularly appealing -- even if one were a VBA expert. I stick by my use of "considerably" if that's what you are complaining about.


"Kent" <kent.spam.account@xxxxxxxxx> wrote in message news:a27rg.128601$IK3.93394@xxxxxxxxxxx
Since that's only one of several possible variations on method 4 (which was a slight variation on his original thought anyway), it's hardly _considerably_ easier, although, I didn't provide the calculation. Again, it will depend on how consistent the original heading entry was. Even with the other methods, how difficult they are is entirely dependent on how facile you are with search-and-replace, and macros in Word and Excel.

Kent

Bill Marriott wrote:
I think it's actually considerably easier than these methods, and doesn't require a script.

Scanning the text, it appears that each line of the entry follows the format



.

Relevant Pages

  • Re: Getting around Dependency Tree Performance Problems
    ... That does not work there is no proper dependency on the Range... ... The Excel Calculation Site ... cell range on my system from 65 seconds to 2 seconds. ...
    (microsoft.public.excel.programming)
  • RE: Cannot get code to work for API Save Dialog Box
    ... Then you could include it in your query and export it to Excel ... to use the default value property of the new text box to do the calculation. ... I checked the cells in the spreadsheet created and the cells are blank. ... cells where you expect the formula to calculate the totals. ...
    (microsoft.public.access.forms)
  • Re: Form Protection with Excel Object Embedded
    ... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the ... Excel workbook, though. ... At most, you'll need to insert a paragraph break immediately before the workbook, then format the workbook ...
    (microsoft.public.word.application.errors)
  • Re: Disabling Autocalculation when opening CSV files
    ... For Each osht In ActiveWorkbook ... I am not very technical in Excel myself but I would like to add that: ... The calculation mode is always set to Manual (without recalculation ... Switch to Manual calculation and turn off Recalculate before save. ...
    (microsoft.public.excel.programming)
  • Re: Path to File
    ... calculation) like this without creating separate fields for them. ... > Hi Bill. ... They navigate to the file on your server. ... >> the address bar of any Windows Explorer or IE window. ...
    (comp.databases.filemaker)
Loading