AnsweredAssumed Answered

Carriage Return in String Literal

Question asked by electon on Mar 28, 2015
Latest reply on Sep 23, 2016 by BruceRobertson

This may sound simple and silly...

I'm trying to get a value list of parameters returned by PsOS where one of the values is also a value list. Therefore I wrap that one in quotes.

Quote ( valuelist ). The value list is gathered from a summary field List Of.

I can unquote the list using Substitute but the carriage returns remain as the character ¶ and Substitute function doesn't find them.

 

I've already got it working by substituting my own separator for the carriage return on server but... Is there a way to do this without the workaround?

 

Any ideas are appreciated.

Outcomes