Brian Dunning's FileMaker Custom Functions

FilterFileName ( text ; filetype )

filtering field contents as a file name when exporting record set to Excel or Acrobat file

  Average rating: 4.5 (34 votes) Log in to vote

Michael Myett   Michael Myett
FileMaker Apps
http://filemakerapps.biz

Share on Facebook Share on Twitter

  Sample input:
Filter File Name ( team , 1 )
  Sample output:
red sox.xls

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

FileMaker allows you to export record sets to either an Excel or Acrobat file. If you are using a scripted export routine using some field contents as an automated file name, this function will filter any characters that would cause a illegal file name ( in windows ). This will avoid an error when running your script, by removing illegal characters.

For example, use the formula to set a variable in a script which exports a record set to an Excel or Acrobat file. The variable would create a filtered file name with illegal characters removed. This is good for Windows only. Sorry. I don't have access to a Mac to work that out and believe there are some different characters. Anyone who would like to add to this for Mac, feel free.

Make file type = 1 to add a Excel file extension to file name or file type = 2 for Adobe Acrobat file extension.

 

Comments

Sean   Sean, Birmingham
Mar 3, 2011
I would change the second parameter to be the extension. That way this function could also be used when exporting container contents.
 
Denise   Denise, Boston
Mar 28, 2014
Exactly what I was looking for. Thank you so much!
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.