Custom Courion Transformation: VB-STRING
December 14th, 2009
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 CourionService\Transformations 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>
