Create a next line after a specific character

ymcmb — Tue, 07 Jun 2022 17:51:26 GMT

Hello,

I have a dimension that has messy data. The dimension we'll call it [Comments].

Comments have data that look something like this (in one cell with multiple lines):

* Marketing campaign in Seattle

- Begin 6/7/2022

1. Revenue growth 20%

I am using NPrinting to display the Comments but it displays as such on the front end:

* Marketing campaign in Seattle - Begin 6/7/2022 1. Revenue growth 20%

My goal is to find the bulletpoint, hyphen, and 1. and creating a next line/break (chr(10))

Using a mixture of pick and wildmatches I get the results I want on a table (testing purposes) in a qlik app with it breaking next line but once bringing that formula into NPrinting, the display reverts to a single line with no line breaks. Any clue or solutions are greatly appreciated.

topic Create a next line after a specific character in App Development

Create a next line after a specific character