Newest functions Upload a function Leave a tip My account

There are 2,527 functions in this library.

MakeFileNameSafe

This function will clean up a string to be a safe file path on Mac, Windows or Linux

  Average rating: 5.0 (1 vote) Log in to vote

Jon Eisen - Show more from this author Richard Carlton Consulting.com https://rcconsulting.com

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

Let ([ ~source = source ; ~replacement = replacement ; output = Substitute ( ~source ; ["#" ; ~replacement] ; ["%" ; ~replacement] ; ["&" ; ~replacement] ; ["{" ; ~replacement] ; ["}" ; ~replacement] ; ["\\" ; ~replacement] ; ["<" ; ~replacement] ; [">" ; ~replacement] ; ["*" ; ~replacement] ; ["?" ; ~replacement] ; ["/" ; ~replacement] ; ["$" ; ~replacement] ; ["!" ; ~replacement] ; ["'" ; ~replacement] ; ["\"" ; ~replacement] ; [":" ; ~replacement] ; ["@" ; ~replacement] ; ["+" ; ~replacement] ; ["`" ; ~replacement] ; ["|" ; ~replacement] ; ["=" ; ~replacement] //spaces ; [Char(9) ; ~replacement] ; [Char(32) ; ~replacement] ; [Char(160) ; ~replacement] ; [Char(8192) ; ~replacement] ; [Char(8193) ; ~replacement] ; [Char(8194) ; ~replacement] ; [Char(8195) ; ~replacement] ; [Char(8196) ; ~replacement] ; [Char(8197) ; ~replacement] ; [Char(8198) ; ~replacement] ; [Char(8199) ; ~replacement] ; [Char(8200) ; ~replacement] ; [Char(8201) ; ~replacement] ; [Char(8202) ; ~replacement] ; [Char(8232) ; ~replacement] ; [Char(8287) ; ~replacement] ; [Char(12288) ; ~replacement] ) //windows sepecific reserved filenames that will cause windows explorer to crash ; output = Case( output = "com1" ; "com" & ~replacement & "1" ; output = "com2" ; "com" & ~replacement & "2" ; output = "com3" ; "com" & ~replacement & "3" ; output = "com4" ; "com" & ~replacement & "4" ; output = "com5" ; "com" & ~replacement & "5" ; output = "com6" ; "com" & ~replacement & "6" ; output = "com7" ; "com" & ~replacement & "7" ; output = "com8" ; "com" & ~replacement & "8" ; output = "com9" ; "com" & ~replacement & "9" ; output = "lpt1" ; "lpt" & ~replacement & "1" ; output = "lpt2" ; "lpt" & ~replacement & "2" ; output = "lpt3" ; "lpt" & ~replacement & "3" ; output = "lpt4" ; "lpt" & ~replacement & "4" ; output = "lpt5" ; "lpt" & ~replacement & "5" ; output = "lpt6" ; "lpt" & ~replacement & "6" ; output = "lpt7" ; "lpt" & ~replacement & "7" ; output = "lpt8" ; "lpt" & ~replacement & "8" ; output = "lpt9" ; "lpt" & ~replacement & "9" ; output = "con" ; "file" & ~replacement & "con" ; output = "nul" ; "file" & ~replacement & "nul" ; output = "prn" ; "file" & ~replacement & "prn" ; output ) ]; output ) Click to copy

There are a handful of specific characters that are commonly used in strings that are unsafe for filenames across all major platforms. This will substitute them with a passed character.

It does not check that the replacement character is safe, nor do I guarantee that it covers all instances.

It also protects you from accidentally creating a file whose name will cause Windows Explorer to crash every time you try to open the file.

Note: this function removes all spaces which are allowed on Unix-based systems but not windows. Just comment that section out if you want spaces to be allowed.

If you find additional characters, let me know and I can add them.

 

Comments

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: