Jump to content

Search the Community

Showing results for tags 'parse'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FM Forums Affiliate Sponsors
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • ISO FileMaker Magazine
    • Open Source Frameworks
    • FileMaker Plug-Ins
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • 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
  • Button Bar Icon - Text Alignment Issue
  • 1-more-blog
  • Productive Computing

Categories

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

Found 6 results

  1. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
  2. Hi all Hopefully this is in the right place, apologies if not. I'm using the technique found in the FM 13 advanced training series to generate virtual lists. I'm using virtual lists to quickly transfer data to a scratch table used for reporting. I have an ExecuteSQL formula to gather some of the data in question: ExecuteSQL ( " SELECT GroupID, SUM(RoundedValue) FROM DataTable_Home WHERE CustID_FK = ? and Code < ? and PeriodNumber = 2 and (GroupID = 68 or GroupID = 3) GROUP BY GroupID "; "|" ; "|" ; Cust_Home::CustID_PK; "500" ) This generates in most cases a dataset of: 68|-3600|3|-7200| <<< as an example for this customer with 68 and 3 being the required group 'names' or headers. This data is passed via scripting into a field on the scratch table called ListData which has several fieldsdedicated to particular values, two of which are dedicated to Group68 values and Group3 values. The formula in each is: Get Value(ScratchTable::ListData;2)<<<For Group 68, -3600 Get Value(ScratchTable::ListData;4)<<<For Group 3. -7200 However, there may be cases where a customer does not have any values associated to either 68 or 3 which obviously reduces the return on the dataset and makes the parse section inaccurate. On my scratch table, I have several fields If a particular customer has NO value for group 68, the returned data set instead looks like: 3|-7200 and this will break all downstream GetValue(Field;x) calculations. So, what I really need to have is a reliable way of ALWAYS returning 4 pipe separated results in the situation that a customer has data missing from one or other of the groups, and that's where I'm stuck. If I could get to: 68|0|3|-7200 or 68|-3600|3|0 as an example, this would enable me to parse the 0 values to where they should be. Any help on this one greatly appreciated. Thanks
  3. I am creating a database solution that needs to read the text from a pdf in a container field and put it into another calculation or field for parsing. I have read many articles and can't seem to find a solution to something that a simple Mac Automator Action can do. I have done this in Filemaker for Mac (not Go) via AppleScripts. I need to do this native to Filemaker without plugins or external scripts as this will end up being on Filemaker Go residing on the tablet/phone. Is this possible?
  4. Troi Automatisering releases Troi Text Plug-in 3.5 for FileMaker Pro 14 August 10th, 2015, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 3.5 for FileMaker Pro 14. What is Troi Text Plug-in? Troi Text Plug-in is a powerful tool for for dealing efficiently with text in your FileMaker Pro database. It adds the following functions to FileMaker Pro: - Parse XML text into fields- Combine sets from 2 text fields: - get all lines that are the same - get all lines that differ - and other combinations- Get (unique) lines and sort words and lines- Make a text sum from a related file that updates without a script What is new in version 3.5? Troi Text Plug-in 3.5 offers the following changes: - Tested and made compatible with FileMaker Pro 12, 13 and 14.- Added support for 64-bit architecture with FileMaker Pro 14: on OS X the 32-bit and 64-bit version is a single universal plug-in and on Windows there are 2 plug-ins: Troi_Text.fmx (for 32-bit) and Troi_Text.fmx64 (for 64-bit).- Added the example file EasyInstallTroiPlugins.fmp12, with support for the 64-bit version of FileMaker Pro 14.- Tested with OS X 10.9 Mavericks, OS X 10.10 Yosemite and Windows 8.x.- Troi Text Plug-in is now compatible to run under FileMaker Server. The plug-in creates log files when running under FileMaker Server to make troubleshooting easier and to provide feedback regarding errors and registration status.- Added new switch -GetRegistrationState to the TrText_Version function to check if the plug-in is currently registered.- Added new switch -GetPluginInstallPath to the TrText_Version function to return the path where the plug-in is installed.- Added new switch -UnregisterPlugin to TrText_Version to remove the registration data. The plug-in will be in the unregistered state after this.- Several bug fixes and further improvements.- Converted the example files to .fmp12 format and made various changes to the example files. More detailed information on all changes and improvements implemented in Troi Text Plug-in 3.5 and earlier can be found at: http://www.troi.com/software/texthistory.html Suggested Uses - Receive client information in XML format and parse it easily into your database- Find all addresses you want to send an email to, without sending duplicates- Create an index for a book, which is updated automatically- Keep track of your client relations by generating a dynamic history of activities- Present portal information horizontally Pricing & Availability A fully functional version of Troi Text Plug-in 3.5 is available for downloading at Troi's web site at: http://www.troi.com/software/textplugin.html Troi Text Plug-in 3.5 works with FileMaker Pro 12, 13 and 14. The plug-in can also be used with runtimes created by FileMaker Advanced 12, 13 or 14. The plug-in is available for OS X 10.6.x or higher, Windows Vista, Windows 7, Windows 8 and Windows 8.1. Licenses cost US$ 49 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site. FileMaker Server requirements Troi Text Plug-in 3.5 also works with FileMaker Server 12, 13 and 14 as a server-side plug-in and as a plug-in used by the web publishing engine and WebDirect. To use this, you need to purchase a special cross-platform Server/Web license which costs US$ 259. We have prepared extensive information on how to install and use Troi Plug-ins server-side and web-side on this web page:http://www.troi.com/support/filemaker-server-side-plug-ins.html Upgrade information Product updates from earlier versions, bought on or after February 1st, 2015, are FREE: eligible users will be emailed a new registration string. Contact us if you have not received yours after August 12th, 2015. Upgrades from licenses bought before February 1st, 2015, are available from US$ 29 per user.Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site. About Troi Automatisering Troi Automatisering develops professional iOS apps, is a leading developer of cross platform FileMaker Pro plug-ins and winner of the FileMaker Pro Excellence Award 2001. For more information, visit our web site at:http://www.troi.com/ Contact information D. BuddingTroi Automatisering Newsroom: <http://www.troi.com/news/>
  5. Hello everyone, I have been working on this for many weeks and unfortunately the newest road block has me stumped. Thank you in advance for any help you can give me. I have 4 text fields in my Event/Guest table: GuestNames, FoodRequest, SitWith and SpecialAccess. For the first time, I am importing this information from an excel spreadsheet downloaded from a vendor. Unfortunately, all 4 questions and their answers are combined into one field, so the imported cell looks like this: If you have purchased tickets for others, please list their names for check in and name tag purposes.: John Doe, Mary Smith | Are there any food allergies?: No | Who would you like to sit with at lunch?: Mary Doe | Do you have any special accessibility needs?: No I have defined some calculation fields to parse the start and end of the questions/answers and it works--as long as the user answers every question. If the guest does NOT answer a question, nothing is sent in that place. This means that the placement of the question/answers is not predictable. Nor is the text that starts at the next question in the line. In an attempt to solve this complication, I have created another calculation field that takes the entire blurb and substitutes a carriage return for each "|", making it a value list. I can search for the text string that is applicable, but how do I retrieve the value of the whole line? If I could do that, I could trim the question off and have my text answer for each of the fields I need. There may be a better way to do it, and I'm open to suggestions. Thank you again!
  6. Hello, I am a FM newbie and have been scouring the web for an answer to this problem: I want to eliminate the text within parentheses in a string, but I want to eliminate all instances: ORIGINAL STRING: This is a test of the (emergency) broadcast system. (It is only a test). Remain calm. DESIRED STRING: This is a test of the broadcast system. Remain calm. Can anyone help? Also, is it possible to tie the function or script to a field so that when the ORIGINAL string is put into the field, the field does the conversion automatically? thanks very much in advance, SB
×

Important Information

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