Enfocus Community

Hi



I have a variable-text that include "", and as default SmartStream don't take any notice about it. It just wright the text as it is.



Later I found that I can change the text-field to other things, and one of them is "Formatted text from DB", but it change nothing then I preview the template.







Is there anyone that have this problem and have a solution for it?



/Thomas

Perhaps try 'n' or whatever they use to mark new lines within cells. Could you use something like text-to-columns to break the field into atomic parts and then use vertical purge to display them one above the other in cases where they exist? Sorry I can't be of more help but Smartstream support is pretty good too.

Ok. I can't change the text-file before it coming in to Switch/SmartStream, so it has to solved there.



I will contact HP to see if they have any advice. Thanks.

Let me understand: Do you want a newline within a database field?

You can try to replace it with n as Gabriel suggested. Simply replace all occurrences of with "n" with script or regular expression before you put the file into the input directory of Smartstream.

Ok. How should 'n' be in the text. Just plain n or with 'n' or "n"?



I tried with n but it didn't work.

Tested more and no luck. Can anyone confirm that it works? Show an example text/picture?



The same variable-text works in other program that do the similar work, eg Cacidi.

Hey Lombert,

Did you ever figure this one out?

Yes, we got this answer from HP;



"Here is R&D reply. It is very simple and I hope it is acceptable…

SmartStream Designer does not support HTML syntax in the database, but there is a simple solution:

The user can click new line (Alt + Enter) in the Excel and SmartStream Designer respects that.



I hope this solution can work for our customer



best regards

Neta"



I have not yet tested it my self.

Thanks for following up. I'm pretty sure that alt+enter includes a 'n' in most spreadsheet formats.