March 11, 201015 yr So I'm trying to do an automated save as pdf in my database. What I want to do is make it possible for someone to save a file by just pasting their path from a Windows Explorer address bar into a custom dialog box in FileMaker. The only problem I am running into is converting the "" over to a "/". For instance if I want to save the pdf in the path C:Documents and SettingsAdministratorDesktop then I need to tell filemaker to find and replace all the 's with a /. And my final save path will look like this filewin:/C:/Documents and Settings/Administrator/Desktop/. The problem I am facing in doing this is that Filemaker recognizes as an operator for division and will not let me put it into a Calculation for a text. ex: Substitute ( $path; ""; "/") Gives me the error "This text constant does not end with a quotation mark." Any ideas???
March 11, 201015 yr It has nothing to do with dividing. is the character for escaping special characters. So in your case you would need something like: Substitute ( YourPathField; ""; "/" )
Create an account or sign in to comment