Windows File Path syntax

[jhomer]

I would like to create Customer folders on the users C drive based on what record the user is viewing.

Thus a send event of:

"cmd.exe /c MD C:Customers" & CustomerName

I receive an error message at then end of the Customers line stating I need a closing quotation mark.

The calc engine will accept this string if the last isnt there.

Could someone help guide me with the correct string?

[comment]

The backslash is reserved as an escape character. In your formula, the combination " escapes the closing quotation mark and turns it into a literal character. Try:

"cmd.exe /c MD C:Customers" & CustomerName

Here the first backslash escapes the second one, so you get a literal backslash character, followed by an unescaped quotation mark.

See also: Help > Creating a database > Working with formulas and functions > Identifying text constants and special characters in formulas

[jhomer]

ARG! THANK YOU.

I need to write this down....thats the second time I've got stumped on that!

Thanks again for you help...

[Lee Smith]

You can make any post a favorite. However, when it is your own, you can find them by going to the Menu >> ACTIVITY >> My Topics.

HTH

Lee