nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to split a string on a row in more rows

vucciria

Hi!
I've a simple question but maybe the solution is not so simple.

I've a report which shows such rows

Column a Column b
123456 1 - 2 - 3

I would have something able to do a split of column b giving more rows such this

Column a Column b
123456 1
2
3

Or the following is good as well (column a is not a problem)

Column a Column b
123456 1
123456 2
123456 3

Column B is a string type

Please could you explain me how to obtain this result without changing the query?

thank you a lot

Find more posts tagged with

Comments

vucciria

elements 1,2 and 3 must be always listed under column b but unfortunately the post lose the formattation

mwilliams

Hi vucciria,

You could use a text control and use javascript and html tags to list 1, 2, and 3 on separate lines. That's one way. You wouldn't be able to use an aggregation element to sum this column still, though if you're after something like that.