Anyne got any ideas as to how to script a find-replace "" with "/" in a field that contains a file path. In a scripted find-replace the is always regarded as an operator, even with the surrounding quotes. It works fine as a manual find replace - but I don't want to pass this on to an end user in my runtime solution.

I want to be able to copy a file path from the OS, paste it to the field and use it to export field contents. The problem is the pasted result has the slashes going the wrong way for Filemaker to interpret as a valid path. Of course this could be corrected manually but it would certainly be more desireable to have this done automatically.

Edited September 19, 200520 yr by Guest

To insert a backslash, use two backslashes

FileMaker uses the as an escape character within text strings in calculations. To display a " in a text string, insert ". To display the backslash, insert . To display a paragraph mark insert ¶ (this may not show properly in all web browsers).

Excellent, thanks - I swear I tried that but you know how that goes -

To recap for those who might find solace in this answer in the future- My Find & Replace criteria reads Find"" replace with"/"

This takes care of the C:FilemakerFolderFIle.ext

to

C:/Filemaker/Folder/FIle.ext

conversion so that filemaker can use the latter path to export a file's contents to the specified directory

Thanks again!