Jump to content

Quito

Members
  • Content Count

    32
  • 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

1,860 profile views
  1. What an elegant solution! Here's my Script Workspace with everything in it. Thank you very much Comment, I really appreciate it.
  2. 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
  3. 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
  4. 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
  5. 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
  6. That worked perfectly Doughemi! Thank you very much!
  7. Hi Lee, Sure thing: [-77.84121237982664,-1.06364908387218], [-77.84166562911301,-1.063525160518601], [-77.84237632439182,-1.063411868215063], [-77.84261193006375,-1.063284600036807], [-77.84265653299182,-1.063260506766708], [-77.84271928886058,-1.063226607398715], [-77.84282835004831,-1.063032767601322], [-77.84286600406656,-1.062984747435158], [-77.5319437625604,0.6486004404427348], [-77.53183056992712,0.6486539147774151], [-77.531751134082,0.6487010449218822], [-77.53169773427386,0.6487465350210897], [-77.53165753615083,0.6487968087259288], [-77.53162461615723,0.6488600039549386], [-77.53158956333689,0.6489673077817226], [-77.53155820366391,0.6490971148515756], [-77.53152359126715,0.649367471361435], [-77.5314980705212,0.6495039651069012], [-77.53139221405952,0.649865012864832], [-77.53130483819433,0.650194416498282], [-78.59388666327277,-0.8382328250941384], [-78.59346449863854,-0.8381310547019249], [-78.59285416063659,-0.8381231110950926], [-78.59205038517958,-0.8381126495159497], [-78.5915825353803,-0.8379765929485172], [-78.59110306730949,-0.837748780848333], [-78.58955391777447,-0.8365195786769242], [-78.58955387377618,-0.8365195750339982], [-78.58933291646856,-0.8362419382737962], [-78.58909508106591,-0.8360332578099272],
  8. Thank you Doughemi, Your script worked beautifully with most coordinates. Please give these screenshots a look. What's weird is: a. latitude coordinates are being stripped of the 0 unit. b. the negative value is conserved. c. If the latitude starts with 1 or -1, then the unit is conserved. All the very best, Daniel
  9. Hi, I have a database with +1000 records, each with a long list of long/lat coordinates that need to be reversed to lat/long. The amount of decimal numbers is not fixed, yet every longitude value starts with an opening bracket "[" and is separated from the Lat value by a comma ",". Each coordinate ends with a closing bracket "]," and a carriage return. I guess if it were just one coordinate I could do it with left, middle and right. Hope someone can ease me towards a solution. Best, Daniel
  10. Hi LaRetta, This is perfect, it works great! Sorry it took so long for my response but I had to read a lot in order to grok your solution. Thank you and all the very best, Daniel
  11. Hi LaRetta, Following your advice to look at the calculation suggested by Comment, I changed your Middle ( field ; start ; end - start ) to Trim ( Substitute ( Middle ( field ; start ; end - start ) ; Char ( 10 ) ; "" ) ) and was able to remove all beginning and trailing Carriage Returns from my text. Thank you and best regards, Daniel
  12. Thank you for the suggestion. I migrated the Script replacements to a calculation field using Substitute and it's working fine. It's also blazingly fast. Best, Daniel
  13. This limit persists in FileMaker Pro 15 for .upr files. I wasted my time creating a 100 000 "compatible" wordlist only to have it truncated at 2882 words during import. It's very annoying as there doesn't seem to be a way to create a main .mpr dictionary file.
×
×
  • Create New...

Important Information

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