Invalid Character in Write Stage

DarinaHendrycho — Tue, 09 Oct 2018 20:29:00 GMT

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

There's probably more…

NoahSommerfeld — Tue, 09 Oct 2018 21:53:00 GMT

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

topic There's probably more… in Product Forum

Invalid Character in Write Stage

There's probably more…