I need to figure out how to make this work to set a file path for windows:
substitute(myfield; "" ; "/")
All I get is this: "this constant does not end with a quotation mark" and then I am unable to save the calculation.
Substitute ( myfield ; "\\" ; "/")
The backslash is a special character and needs to be escaped.
In filemaker, the \ is treated as a flag to escape the next character (so you can do things like place quatation markes inside a string)
substitute (myfield ; "\\" ; "/")
Retrieving data ...