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.