I am using the Generate Word Document Smart Service and I need to pass an array,

scottl189 over 8 years ago

I am using the Generate Word Document Smart Service and I need to pass an array, and display each item in the array on a new line. How can I do this? Using joinarray(pv!MyMultipleProcessVariable,char(13)&char(10)) does not work as it does for text docs.

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 8 years ago

@scott: I suggest you create a global rule to "sanitize", let's say, general text that you pass into a word document. Among other things, you would want to replace char(10) characters with , strip out (and otherwise ignore) char(13) characters, and do something about "&", "<" and ">" characters.
Then you can use the code snippet you wrote originally, and pass it through this new rule, and I would suggest you pass anything else that could be user-entered through this rule as well.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 8 years ago

@scott: I suggest you create a global rule to "sanitize", let's say, general text that you pass into a word document. Among other things, you would want to replace char(10) characters with , strip out (and otherwise ignore) char(13) characters, and do something about "&", "<" and ">" characters.
Then you can use the code snippet you wrote originally, and pass it through this new rule, and I would suggest you pass anything else that could be user-entered through this rule as well.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data