Jump to content

Search the Community

Showing results for tags 'extracting text'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting


  • Community Calendar
  • FileMaker User Groups

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 3 results

  1. Greets, all: I'm > this < close but just can't seem to nail it. I'm using a value list that concatenates from another table the values of city, state, and country--that's being used as a key--so it looks like this: Lewiston|ID|US Coeur d'Alene|ID|US Boise|ID|US As part of another calculation, I want it to extract whatever the two-letter state code is ("ID", in these examples) irrespective of the length of the city name. I got this far: Middle ( JOB::Company_City__lxt ; Position ( JOB::Company_City__lxt; "|" ; 1 ; 1 ) ; 3 ) ...but I can't figure out a way to dump the pipe ("|") character so I don't end up with "|ID". Also, since the calculation will always result in the format, "|two-letter state|two-letter country", would using the Right text function be more elegant/effective to grab the state code? Cheers, Rich
  2. Hello Am trying to clean up the email field on a filemaker database. At the moment there are many records that contain more than one email address or an email address and text. what I want to do is delete everything in the field apart from the first email address In the vast majority of cases the required email address is the first thing in the field. So my thinking is that the script would have to read along until it found an "@" symbol and then truncate the text at the next space comma or backward or forward slash as they are generally the methods people have used to separate the email addresses. Apart from that am struggling - I would be delighted if someone could give me some pointers on this
  3. I am trying to figure out how to extract a portion of a filename from a field, when the filenames differ. It is for a file database. This would be easy if all the files are named the same, but we have multiple different filenames based on the type of file it is. So the idea is I have a "shot_name" field that pulls in the name from the file I am importing into FileMaker. For instance, here are two of the filenames...one is for a traditional shot and one is for a development shot. Traditional Shot: BOG8515_150731_Line-Up Development Shot: BDC_dev9150_150721_Line-Up Essentially the only portion of the shot I want is the following for each: Traditional Shot: BOG8515 Development Shot: BDC_dev9150 I believe there would only be these two variables I would encounter, however the end of the filename may change from _Line-Up to _Change from time to time. Is there a way to strip out only the shot name? Can't quite wrap my head around how I would do that in a calculation field. Any tips or advice would be greatly appreciated!
  • Create New...

Important Information

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