You are not logged in.
I could not found how to do this job (here simplified from the real case) :
1/ One excel file with two columns : server, platforms
2/ The field server contains the name of a server
3/ The field contains one or more platforms (a server could be shared on different platforms), comma separated (ex: 'PF1, PF2, PF3')
for this example :
server2 'PF2, PF3'
server3 'PF3, PF1, PF2'
i want to generate :
Please, could you explain me which components to use ?
I can use a perl component but i am not sure how to create a new row on output.. ?
using a map and the value 'split /,/, $row1[platform]' i can count the number of platforms for a server but i don't know how to use it with efficiency..
Thanks a lot for your help.
correction: 3/ The field platforms contains one or more platforms
OK, linked to [Forum, topic 329] splitting a string into rows.
Sorry for the post.