I have made a rather large table and I want to extract certain data from that to a rich text field.
I have written the following formula - concat(svr1, SERVER, svr1, NTUN, svr1, ",", phylocal, ",", platform)
and it works great.
However I want to write one for each row in the table and have them go to the next line after the 'platform' entry.
Obviously this doesnt work but this is how I would like the output to be:
concat(svr1, SERVER, svr1, NTUN, svr1, ",", phylocal, ",", platform)
concat(svr2, SERVER, svr2, NTUN, svr2, ",", phylocal, ",", platform)
concat(svr3, SERVER, svr3, NTUN, svr3, ",", phylocal, ",", platform)
Any help would be much appreciated, I have tried everythin in my limited knowledge.
Thanks