I recently ran into a situation where I needed to take the output of a macro and assign it to a variable in a separate VBScript Courion macro. In order to handle the line returns as well as embedded quotation marks I created a custom transformation. To implement, simply create a file called CustomTransformations.xml in the CourionServiceTransformations Directory, and include the following XML Code:
<?xml version="1.0" encoding="UTF-8"?> <transformations> <!-- VBScript String Adds leading and trailing quotes, escapes internal quotes and handles crlf's--> <transformation name="VB-STRING"> <prefix>"</prefix> <replacements> <replace from=""" to=""""/> <replace from="
" to="" & vbcrlf & ""/> </replacements>; <postfix>"</postfix> <seperator> & "," & </seperator> </transformation> </transformations>
Recent Comments