Formatted text in HP SmartStream

Post Reply
lombert
Member
Posts: 167
Joined: Fri Feb 04, 2011 2:31 pm
Location: Sweden

Formatted text in HP SmartStream

Post by 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
Between jobs!
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Formatted text in HP SmartStream

Post by 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.
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
lombert
Member
Posts: 167
Joined: Fri Feb 04, 2011 2:31 pm
Location: Sweden

Formatted text in HP SmartStream

Post by 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.
Between jobs!
ArielRauch
Advanced member
Posts: 231
Joined: Thu Aug 07, 2014 10:04 am

Formatted text in HP SmartStream

Post by 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
Member
Posts: 167
Joined: Fri Feb 04, 2011 2:31 pm
Location: Sweden

Formatted text in HP SmartStream

Post by 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.
Between jobs!
lombert
Member
Posts: 167
Joined: Fri Feb 04, 2011 2:31 pm
Location: Sweden

Formatted text in HP SmartStream

Post by 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.
Between jobs!
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Formatted text in HP SmartStream

Post by gabrielp »

Hey Lombert,

Did you ever figure this one out?
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
lombert
Member
Posts: 167
Joined: Fri Feb 04, 2011 2:31 pm
Location: Sweden

Formatted text in HP SmartStream

Post by 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.
Between jobs!
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Formatted text in HP SmartStream

Post by gabrielp »

Thanks for following up. I'm pretty sure that alt+enter includes a 'n' in most spreadsheet formats.
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
Post Reply