Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Quito

  • Rank

Profile Information

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

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

1,718 profile views
  1. 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
  2. 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
  3. That worked perfectly Doughemi! Thank you very much!
  4. 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],
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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.
  11. Hi Kalle, Just a few thoughts. The E-utility Web Service (SOAP) was terminated on July 1, 2015. See https://www.ncbi.nlm.nih.gov/books/NBK43082/?report=reader. The new syntax is provided here: https://www.ncbi.nlm.nih.gov/books/NBK25499/?report=reader#chapter4.Eutility_DTDs Please check this page regarding the NCBI migration to https on September 30, 2016: https://www.ncbi.nlm.nih.gov/home/develop/https-guidance/ If you are interested in fleshing out the complete xsl for FileMaker using the PubMed DTD, let me know. It's close to 3000 options and I've managed to write the main 500 or so. Best, Daniel
  12. Hi, I'm writing a find-replace script to change special characters to Unicode code and another script to change them back to special characters (see screenshot). It seems I should be able to assign the "Go to Field" once and run ~1000 Find/Replace(ments) in one go. I'm not going to switch to another Field during this process. Is the Script Workspace the right way to do this or would it make sense to have the Find/Replace units in another .fmp12 file? Best, Daniel
  13. I tested this and got a "The specified field cannot be found". "Set Field" was highlighted. *Sigh*
  14. Hi Doughemi, That was it! I was able to split the first chunk at 1815/1880. Thank you for the sharp eye! Although the number 1880 is indeed arbitrary, I am trying to avoid problems in the future. OK, so first problem solved. This is what Chunk1 looks like now: Let( [ MaxString = Left( Source_text ; 1880 ); PeriodCount = PatternCount( MaxString; ". " ); PeriodPos = Position( MaxString; ". "; 1; PeriodCount ); Substring = Left( MaxString; PeriodPos ) ]; Substring ) Chunk1 selects the last "period-space" within the first 1880 characters in the "Source_text" text field. Chunks 2 to 5 are shown in the screenshot. I need to modify Chunk2 so that instead of capturing from 1881 onwards it should 1. Either capture from the last "period-space" or 2. Perform a Length (Chunk1) and use that number to determine where Chunk2 should start. I'll try #2 first. Seems easier.
  • Create New...

Important Information

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