Formatted text in HP SmartStream

[lombert]

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

[gabrielp]

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.

[lombert]

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.

[ArielRauch]

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.

[lombert]

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.

[lombert]

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.

[gabrielp]

Hey Lombert,

Did you ever figure this one out?

[lombert]

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.

[gabrielp]

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