Formatted text in HP SmartStream

lombert · Post by **lombert** » Wed Nov 12, 2014 2:27 pm

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 · Post by **gabrielp** » Wed Nov 12, 2014 4:19 pm

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 · Post by **lombert** » Wed Nov 12, 2014 9:23 pm

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 · Post by **ArielRauch** » Thu Nov 13, 2014 9:46 am

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 · Post by **lombert** » Thu Nov 13, 2014 12:04 pm

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 · Post by **lombert** » Thu Nov 13, 2014 12:53 pm

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 · Post by **gabrielp** » Tue Nov 18, 2014 6:11 pm

Hey Lombert,

Did you ever figure this one out?

lombert · Post by **lombert** » Tue Nov 18, 2014 6:39 pm

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 · Post by **gabrielp** » Tue Nov 18, 2014 7:31 pm

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