cancel
Showing results for 
Search instead for 
Did you mean: 

separate the content one line by line

azazeererer
Participant
0 Kudos

Hello,

i work with Bo4.2 sp7.

I have a "Managers" attribute which contains a list of first and last name, separated by ";", living in a city. example

I want for each city to display the first and last name for in a separate line, as follows :

it is possible ?

thanks in advance

View Entire Topic
ayman_salem
Active Contributor

possible solution is to replace ; with CR

ex:

v_Manager: =Replace([Managers];";";Char(13))

azazeererer
Participant
0 Kudos

so the newline will stay in the same cell. it is not possible that it is a value per line and cell? like this =>

ayman_salem
Active Contributor
0 Kudos

No, as I know it's not possible to split them into many rows

azazeererer
Participant
0 Kudos

very thanks to you.