The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

FILEMAKER: Exporting TextStyleAdd Changes

Get real time updates directly on you device, subscribe now.

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

A READER ASKS …
While searching on the web, I came across your Blog, FILEMAKER: The TextStyleAdd Function. It was exactly what I was looking for except for one item. I want to export the information in the FileMaker Database to comma delineated text format. When I exported the data, I did not get all lowercase for the one field. I have over 90,000 student usernames, etc. to convert. The only problem is this one field which must be all lowercase for the state department.

———————-
DWAYNE RESPONDS
Well, there are a number of things you can do. So I’ll just run the gamut of options and let you see if one works out for you. Now, none of these use the TextStyleAdd function but instead use the Lower function.

EXPORT A CALC FIELD INSTEAD
The lowest impact would be to create a calculation field that uses the lower function and then export that field instead. For example, Lower ( Blog Title ) for this record in the FileMaker database I use to create my blog would return, exporting textstyleadd changes. In your scripted export, substitute the calculation field for the calculated one.

REPLACE COMMAND
Replace the contents of the field with the lower version of itself. So if I wanted to make my blog title field lower case for all records in the found set, I would use the replace command and use the calculated value of Lower ( Blog Title ).

INTERACTIVELY CHANGING THE TEXT OF THE FIELD
Going forward, you may want to have the field interactively change case as the user exits the field. This can be done via the auto enter calculated value with the “do not replace” option unchecked.

© 2010 – Dwayne Wright – dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More