#text manipulation

———

Form Tool to Convert Spaces in a line of text to Hyphens, option to Condense consecutive Hyphens into a single Hyphen.

By: John

Photoshop – Glossy Text

I didn’t have a lot of time today for Photoshop, so I went with a relatively simple tutorial.   I will say that I have been consistently impressed with the quality of tutorials from Blue Lightning TV and if you are trying to learn Photoshop I recommend their channel. That said, I did just update to Adobe Photoshop 2018 and that came…

I intend to keep doing a daily Photoshop tutorial, but I’ve decided to stop numbering them and making the post titles longer than necessary.  It was annoying me and looked weird on mobile devices.  For today, I decided I wanted to set something on fire.  I’ve personally always felt a special kinship to fire.  I went with this tutorial.…

Updated text manipulation plug-in for FileMaker Pro 15 adds compatibility with FileMaker Cloud.

October 27, 2016, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 4.1 for FileMaker Cloud.

First plug-in for FileMaker Cloud

Troi Text Plug-in 4.1 is the first public plug-in that can run in FileMaker Cloud, the cloud-based platform for managing and running custom apps of FileMaker Inc. Troi Text Plug-in can easily be installed with a script to FileMaker Cloud, providing easy acces to the power of its text manipulation functions to developers and organizations.

Peter Baanen, company president, states: "We are very excited to be able to add a new platform that our plug-ins can run on. We are working hard on new FileMaker Cloud compatible versions for our other plug-ins too."

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 and FileMaker Cloud:

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

Customize spell checking*

* currently not available on FileMaker Cloud

What is new in version 4.1?

Version 4.1 is compatible with FileMaker Cloud: you can now install Troi Text Plug-in on FileMaker Cloud and run its functions on the FileMaker Cloud server. We have created a new example file, which demonstrates how to perform the functions of the plug-in on FileMaker Cloud.

Testing in the cloud

The plug-in is fully functional in demo mode, but will stop working after two hours. We added a new switch to the TrText_Version function, which allows you to test the plug-in for two hours more, after the initial two hour period. After 12 hours the demo time is automatically reset, and you can continue testing the plug-in.

To register the plug-in on FileMaker Cloud you need a Server/Web license.

More detailed information on all changes and improvements implemented in Troi Text Plug-in 4.1 and earlier can be found at: http://www.troi.com/software/texthistory.html

More information on Troi plug-ins for FileMaker Cloud can be found at: http://www.troi.com/filemaker_cloud.html

Pricing & upgrade information

A fully functional demo version of Troi Text Plug-in 4.1 is available for downloading at Troi's web site at: 

http://www.troi.com/software/textplugin.html.

Licenses cost US$ 49 per user. Details on other licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.

Upgrading to version 4.1 is free for all users of version 4.0.x: version 4.1 works with the same registration as the 4.0.x version. Product updates from earlier versions, bought on or after August 7, 2015, are free too: eligible users have been emailed a new 4.0 registration string. Contact us if you have not received yours.

Upgrades from licenses bought before August 7, 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 has over 15 years experience in developing high quality cross platform plug-ins for FileMaker Pro and is winner of the FileMaker Pro Excellence Award. For more information, visit our web site at: http://www.troi.com    

Various fuzzy string match algorithms & Excellent video review

I’ve been studying up on fuzzy string match after controlling for misspellings, typos, dyslexia etc.  and I found a few articles discussing various approaches like:

Levenstein distance Damerau–Levenshtein distance n-gram Soundex Jaro-Winkler distance Jaccard index

I found this video from two guys which took a process of checking to see if a name was on a terrorist watch lists which originally took 14…

Text file explorer-Determine file headers & delimiters without opening file

Text File Explorer

I often work with large text files in which the file extension (.txt, .dat, .csv, .tab) doesn’t always indicate what type of delimiter is used in the file.  When the file is small, I’ll typically just “pop” it open in SciTE / Notepad.  Large files (anything over 20 megs) often take a fair amount of time to read and very large files ( a gig or more) will often run into out of…