Jump to content

Quito

Members
  • Content Count

    39
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Quito

  • Rank
    newbie

Profile Information

  • Industry
    Healthcare - Research
  • Gender
    Male
  • Location
    Quito
  • Interests
    Google Neural Machine Translation; Artificial Intelligence; Big Data; Virtual Libraries

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    17

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Mojave

Recent Profile Visitors

2,019 profile views
  1. Yes, I was thinking of something similar. I'm worried it might be overkill, though. Currently, with my massive substitution list there is a 2 second delay when going from one full record to the next. I added tab controls to sort the two dozen or so portal fields and discovered that if I select an "empty" tab control, delay is reduced to zero. I added visual indicators to know beforehand which tab control is empty when I need to see portions of the full records in "Quick mode". This will give me some more time to think it through. Thanks Comment, I'll look further into your solution over the next couple of months and post again afterwards. Best regards, Daniel
  2. Hi Comment, I tried your demo and ran into the following problem: Codes are not unique (as I have dozens of synonyms for each code) but patterns are. So, in your Patterns table I removed Unique from Code and placed Unique on Pattern. Nonetheless, when I click on the Get Codes button, it recovers any pattern that coincides with the first word. Please see the attached screenshot. Best regards, Daniel
  3. I haven't found another explanation. If the filename ends in, for example, _ASG.sql, the BOM character appears on every line in the list. I've even tried using SUBSTITUTE and LEFT to nab the BOM character. Nothing else works. Best, Daniel
  4. Hi, If you've ever been stuck with unwanted invisible unicode BOM characters inside your List, there is a workaround: The zero width no-break space (BOM character) can be represented as: --------- Char ( 65279 ) or \x{FEFF} or <U+FEFF> ... ---------- The BOM character may appear when you export your list, regardless of the TextEncode/LineEndings you selected. In order to avoid this pesky character entering your exported file (in the wrong position), specify _ENC at the end of the filename: ----- Set Field [ YourContainer ; TextEncode ( $q ; "utf-8" ; 1 ) ] Export Field Contents [ YourContainer ; "YourExportedFile_ENC.sql" ; Automatically open ; Create folders: Off ] ----- Hope this is useful to others!
  5. Hi Comment, Sorry for the delay in responding. I agree, the software does what it's intended to do, yet it'll reach a performance hit real soon. I must find a better way to process the data. The input has no rules, so I'm creating rules on the fly (catching phrases, misspellings, and key words). The example you provided sounds viable for my task. Could you please elaborate a bit further? I know how to perform Lookups in Excel and Google Spreadsheets, but I'm a bit lost on how to set it up in FileMaker. I've seen a bit in the FMForum but it still surpasses me. Regarding your question: the tool also performs as a visual checker, as it's necessary to determine if a specific symptom belongs to the patient (or is otherwise being pulled from the family history), if its current (or a past reason for the patient approaching the hospital), or if it's a greedy code error. Your question rings true, as I should harvest the codes only from a few specific fields but the problem is that the needed information is dispersed among all fields and large timestamp ranges.
  6. Thanks Comment, The original text is UTF-8 Uppercase. I believe the maximum number of characters allowed per field on the AS400/9i is 82. In the screenshot, the first field holds the initial text. The text can be substituted by one or many substitution filters. The last one should harvest the code between parenthesis and send it to a plain text field. Indeed, it is possible to have multiple substitutions in a single field. Please see the second screenshot. All the very best, Daniel
  7. Hi, I've created a few thousand (or more) substitutions where a code is appended to a phrase, such as: Substitute ( text ; ["DIABETES MELLITUS, TYPE II";TextStyleAdd("Diabetes mellitus, type II (E119)";Bold+ HighlightYellow)]; ["ALZHEIMER'S DISEASE";TextStyleAdd("Alzheimer's Disease (F009)";Bold+ HighlightYellow)]; ... and so on. I'd like to harvest the codes that have been added to the text and list them, first alphabetically, then numerically. Using the previous example the resulting harvested file should look like: Date | ID | Code 1 | Code 2 2019-05-23 | HGTY87654 | (E119) | (F009) Currently, I'm harvesting the codes by hand but, as the database grows about a million records every 3 months, it's slowing down FM and the tediousness of it is wearing me out. The records are pulled from an AS400 i9 DB2 using DBeavers' JDBC to populate FM17a. There's probably a much simpler way to catch the codes. I can imagine it's possible do three (or four) chores in one go (Substitute; TextStyleAdd; Export Code to another field, Remove duplicates if found). I'm open up to any suggestions. Best regards, Daniel
  8. What an elegant solution! Here's my Script Workspace with everything in it. Thank you very much Comment, I really appreciate it.
  9. Hi, I receive Excel files weekly with some columns I need to clean up, in order to produce SQL queries. I'm thinking of importing the Excel to FileMaker to have it generate the SQL queries. The SQL script then connects to an AS400 i7 series, via DBeaver (using its freeware JDBC) and retrieves tabbed text, which is imported into FileMaker for analysis. A previous post resolved how to deal with fixed-length formats and how to export multiple records (rows) in a simple yet effective manner, and has taken a significant part of the burden away for me. Here's the original post, with the solution given by Comment (EightCharFile2.fp7.zip ) The generated SQL needs a chunk of text at the beginning and at the end of the script. For sake of brevity, one non-repeating Header and one non-repeating Footer for DBeaver to interact correctly with the AS400. Something like this: ----- HEADER (IRMHIS= 11631366 AND IRMDEP= 3590 AND IRMCIT BETWEEN 20190223 AND 20190225) OR (IRMHIS= 17804117 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190400 AND 20190402) OR (IRMHIS= 14058310 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190401 AND 20190403) OR FOOTER ----- Instead of this: ----- HEADER (IRMHIS= 11631366 AND IRMDEP= 3590 AND IRMCIT BETWEEN 20190223 AND 20190225) OR FOOTER HEADER (IRMHIS= 17804117 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190400 AND 20190402) OR FOOTER HEADER (IRMHIS= 14058310 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190401 AND 20190403) OR FOOTER ----- I can imagine that the last OR can be erased on the fly, as well. I know I'm performing unnecessary steps, as the cleanest solution would be FileMaker interacting directly with the AS400, but for now the Excel2FileMaker_SQL-DBeaver2AS400 is how I'm authorized to proceed. Best, Daniel
  10. Hi Comment, This great example produced just what I needed to fill the nasty part of my SQL Script! How would you add a block of text once at the beginning (Header) and once at the end (Footer) of the exported text, without having them repeat themselves? Something like this: ----- HEADER (IRMHIS= 11631366 AND IRMDEP= 3590 AND IRMCIT BETWEEN 20190223 AND 20190225) OR (IRMHIS= 17804117 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190400 AND 20190402) OR (IRMHIS= 14058310 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190401 AND 20190403) OR FOOTER ----- Instead of this: ----- HEADER (IRMHIS= 11631366 AND IRMDEP= 3590 AND IRMCIT BETWEEN 20190223 AND 20190225) OR FOOTER HEADER (IRMHIS= 17804117 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190400 AND 20190402) OR FOOTER HEADER (IRMHIS= 14058310 AND IRMDEP= 3552 AND IRMCIT BETWEEN 20190401 AND 20190403) OR FOOTER ----- I can imagine that the last OR can be erased on the fly, as well. Please let me know if I need to move this question to another (new) topic. Best, Daniel
  11. Thank you Gopala and Comment, Basically, I would like to style certain words or phrases in a text field. I want to style whole words only. Selecting the phrase by adding delimiters (space, comma, dot, semicolon, apostrophe, etc) is simple and works fine. The problem is isolating single letter words followed by a colon, such as: S: O: A: P: Because TextStyleAdd doesn't search for whole words, I end up with words ending in S: O: A: P: also being styled (See attached file). So, the script should do something like: If there is a whole word, formed by a single letter (any of these four letters S, O, A or P), at the beginning of the field, followed by a colon, make it Bold Hope this helps. All the very best, Daniel
  12. Hi, Using TextStyleAdd, I want to change the style of a single letter at the beginning of a sentence. For example: // SOAP [ "S:" ; TextStyleAdd ( "S:" ; Bold ) ] ; [ "O:" ; TextStyleAdd ( "O:" ; Bold ) ] ; [ "A:" ; TextStyleAdd ( "A:" ; Bold ) ] ; [ "P:" ; TextStyleAdd ( "P:" ; Bold ) ] ; But I get this: P: - P: (correct) SOAP: - SOAP: (incorrect) SOFA: - SOFA: (incorrect) Is there a way of adding search constraints to TextStyleAdd? Or, is there a hidden character at the beginning of each line I can capture? All the very best, Daniel
  13. That worked perfectly Doughemi! Thank you very much!
×
×
  • Create New...

Important Information

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