Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Quito

  • Rank

Profile Information

  • Gender
  • Location
  • Interests
    Google Neural Machine Translation; Artificial Intelligence; Big Data; Virtual Libraries

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

1,610 profile views
  1. That worked perfectly Doughemi! Thank you very much!
  2. 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],
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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.
  9. 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
  10. 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
  11. I tested this and got a "The specified field cannot be found". "Set Field" was highlighted. *Sigh*
  12. 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.
  13. Source_text is split into Chunk1, Chunk2, Chunk3, Chunk4 and Chunk5 fields. The problem is that the words are being split in two because the 1880 limit doesn't have any filter to stop sooner (to avoid the word-split). Stopping at the end of the word isn't a viable option either as I need the entire sentence.
  14. Thanks for your response. I have text fields with +8000 characters within. I need to separate the text into text chunks no larger than 1880 characters for further processing. As the Let() calc didn't work, I split the Let() calc into five separate fields (see screenshot). It's not elegant, but it works. So, I have my 1880 character text chunks but they're splitting words. I would like to add the ". " PatternCount and PeriodPosition in order to avoid the word-splitting. Hopefully this makes my question clearer.
  15. Hi, Charles Ross (Chuck) posted the following script in 2010 to split the contents of a text field into text chunks, using the last period (within a period count) as text chunk separator: Let( [ MaxString = Left( String; 100 ); // Get the first 100 characters of the original string. PeriodCount = PatternCount( MaxString; "." ); // Find out how many periods are in the substring. PeriodPos = Position( PeriodCount; "."; 1; PeriodCount ); // Get the position of the last period. Substring = Left( MaxString; PeriodPos ) ]; Substring ) I've only been able to get the first line to work with a given number of characters: Left ( String ; 1880 ) When I add the rest of the script there is no error message, yet nothing is recovered from the String. The second problem I have is: As the remaining text will not necessarily start at 1880, how do I calculate the recovery of the remaining text after the first text chunk is collected? Thanks very much beforehand, Daniel

Important Information

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