Jump to content

Search the Community

Showing results for tags 'substitute'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Proof+Geist
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development
  • FileMaker Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 8 results

  1. 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
  2. I have a field that receives a bunch of first names from a portal, thanks to the List function. The result might look like this: Alice, Bill, Chuck However, I need for the list to read: Alice, Bill, and Chuck I need to find the last comma in the text and add an "and" to it. I have been messing around with the Position function stuffed inside of a Substitute function, but I can't get it right. Can someone help? FMPA14 Rick A. Pleasanton CA
  3. I have a script that loops thru [ go to next ] tab designated fields on a layout and generates a substitution list as such ; "[\""&Get ( ActiveLayoutObjectName ) & "\"; " & Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName )&"];" appending "Substitute(report flow data::report" and ")" at end (report flow data:: report) being a template loaded with "key words" example; Substitute(report flow data::report ["rdate"; report flow data::flowtest_date]; ["rgpd"; report flow data::gallons per day; ["syaddress"; selected system::c_NameAndAddress]; ["wdesc"; selected_water::c_waterDescBasic] ) the key words to be substituted are the individual fields given name and for easy remembering that fields tooltip as well , is it possible to script edit the fields name thus editing the "key word" This custom function "substitute data" substitutes with the scripted text chunk pasted into the function. how to utilize variable $$sublist in place of text chunk apparently one can only substitute text ? it appears that a calculated number doesn't work.
  4. Hi! English is not my native language and I'm using FileMaker in a other language so some spelling/translation errors might occur. I have searched and tried to find a solution for this but couldn't find any. I have a text field, let's call it "Table::Colors", where users either write values manually or paste values. Most of the time the user paste in values. I want to make a script/calculation that changes the pasted value so it becomes correct. --- The user usually paste something like this: "1Green 2Dark blue 10Red3 15Yell0w Purple4" --- I have a script that runs when the user enters/exits the field that looks like this: "Insert text [Table::Colors; Substitute(Table::Colors;["¶";", "];["1";""];["2";""];["3";""];["4";""];["5";""];["6";""];["7";""];["8";""];["9";""];["0";""])" I also have an auto-enter calculation on the field itself and have set it to replace existing value. It looks like this: "TextFormatRemove(If(Right(Table::Colors;2) = ", " ; Left (Table::Colors ; Length(Table::Colors) - 2 ) ; Table::Colors ))" When the user exits the field the value now looks like this: "Green, Dark blue, Red, Yellw, Purple" --- However I want it to look like this: "Green, Dark blue, Red3, Yell0w, Purple4" Basically I want to remove numbers in the beginning of each line but not the numbers that are in the middle or last. Is there a good way to do this?
  5. Hello, In the address section of my database, when you select either Canada or USA it provides a list of relevant ‘Provinces’ or ‘States’ in the Province/State field. Currently the provinces/states are written in full but I would like that once a selection is made, the field automatically inputs the abbreviation - ex. someone selects ‘Saskatchewan’ and it auto-enters/replaces it to ‘(SK)’ on commitment. I managed somewhat to achieve this using the substitute function but only for one entry, I was not able to enter multiple substitutions – ex. Substitute (Province ; “Saskatchewan” ; “(SK)”). Is there a way to enter multiple substitutions as a conditional value? Is this the best way to go about it? FYI, my address section is linked to conditional value lists with the following fields: Country (list of countries) Prov/State (list of provinces and states) Prov/StateAbb (list of provinces and state in abbreviated form) Thank you in advance for your help!
  6. Hi All, I have this fairly simple field, it's a calculation that returns a list, and it works well: If ( IsEmpty ( IP Addresses::IPv4 Address ); "No Static IP"; List ( IP Addresses::IPv4 Address ) ) However, in the resulting list that displays, I'd like to substitute the carriage returns with commas, and I've come up with this bit of code to make the substitution: Substitute ( IP Address Display; "¶" ; ", " ) Is this correct? If so, where do I place the substitute statement? Will it go into the same calculation I use to define the field, or do I have to put this into a brand new field of its own? Thanks in advance, C
  7. I have a text field containing reports imported from an electronic patient record DB. These reports have tons of open space between paragraphs etc, making reading difficult (much unnecessary scrolling). There are no excess space characters, and trim() has no effect (many records start with multiple empty lines). Presumably there are invisible <CR> characters all over the place, but I can't strip them out with substitute (field; "¶¶" ; "") or anything similar. Any suggestions on how to edit invisible characters with the calc engine? thanks!
  8. I'm working on a database where users can search by a person's name. Many of the names in the database have accents and other diacritical marks which it's important for us to keep and display properly. Unfortunately, if a user searches by typing in "Francois," the record for "François" will not be returned. Since it's a pain (at least on a Windows machine) to find and use those special characters, or the user might not even know that André actually has an "é" at the end of his name, I'm looking for a way to ensure that a search for a name that includes a character without a diacritic will find the name that has a character with the diacritic. I've seen a number of inquires about the need to strip letters of their diacritical marks using a substitute function, but I haven't come across a way to incorporate this into a setup where the name displays with the proper diacritic but appears, when being searched, as though it doesn't have any accent or other mark. I appreciate any help with this problem.
  • Create New...

Important Information

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