Invalid Character in Write Stage

[DarinaHendrycho]

Hello, I am experiencing a problem with BP - Write stage. I am trying to write into specific textbox in SAP a file name, where I would like to export my previously automated data from SAP. However, BP does not allow me to include several characters to paste into textbox. More precisely, BP label this error as Invalid escape character U... My file name includes a path just like this:  C:\Users\... I need to preserve this \ otherwise I wont be able to save my excel from SAP. Thank you for any ideas

[NoahSommerfeld]

There's probably more elegant ways to do this (with proper escaping of text), but in the past I've used the 'chr()' function to represent my illegal characters and concatenated with the rest.  i.e to get a string With \backslashes\ I would put ""With ""&Chr(92)&""backslashes""&""Chr(92) into the calculation field. For ascii codes see http://ee.hawaii.edu/~tep/EE160/Book/chap4/subsection2.1.1.1.html