webi report format data

[former_member587206]

i do have a concatenated date string, and i need to split this values into below format, is it possible

eg; 10-10-2020 00:00:00 ; 10-11-2020 00:00:00 ;10-12-2020 00:00:00 ;

need to convert

10-10-2020 00:00:00

10-11-2020 00:00:00

10-12-2020 00:00:00

[mhmohammed]

Hi Vinay,

You can show those values in different lines (but they'll be in one cell only) just like word wrap. Try the below formula.

=Replace([ObjectName];";";char(13)+char(10))

http://www.dagira.com/2009/11/25/displaying-userresponse-values-on-separate-rows/

Thanks,
Mahboob Mohammed