How to avoid results merged into a single line in Splunk csv alert attchment

[spl10]

Hello Splunkers,

My clients are experiencing issue because of the formatting of the results which is present Splunk vs which is sent as a part of attchment.

This is how it is showing in Splunk

jacquetta@evie.com	LOU - HONG	hong-lou-victorina-sid-001k1.active.zenobia hong-lou-victorina-sid-000r1.active.zenobia hong-lou-victorina-sid-001e1.active.zenobia hong-lou-victorina-sid-003f1.active.zenobia hong-lou-victorina-sid-004i0.active.zenobia hong-lou-victorina-sid-002d0.active.zenobia hong-lou-dvpqlqwpy005-001k1.active.zenobia hong-lou-dvpqlqwpy005-000r1.active.zenobia hong-lou-dvpqlqwpy005-001e1.active.zenobia hong-lou-dvpqlqwpy005-003f1.active.zenobia hong-lou-dvpqlqwpy005-004i0.active.zenobia hong-lou-dvpqlqwpy005-002d0.active.zenobia hong-lou-dvpqlqwpy005-004r1.active.zenobia hong-lou-dvpqlqwpy005-006z0.active.zenobia hong-lou-stephany-001k1.ae.active.zenobia hong-lou-stephany-000r1.ae.active.zenobia hong-lou-uvyycdyjewys-001k1.ae.active.zenobia hong-lou-uvyycdyjewys-000r1.ae.active.zenobia hong-lou-uvyycdyjewys-001e1.ae.active.zenobia hong-lou-uvyycdyjewys-003f1.ae.active.zenobia hong-lou-jackeline-001k1.ae.active.zenobia hong-lou-jackeline-000r1.ae.active.zenobia hong-lou-jackeline-001e1.ae.active.zenobia hong-lou-jackeline-003f1.ae.active.zenobia hong-lou-proxy-001k1.active.zenobia hong-lou-proxy-000r1.active.zenobia	Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs
jacquetta@evie.com	AE Member Services - HONG	hong-member-001k1.ae.active.zenobia hong-member-000r1.ae.active.zenobia hong-member-001e1.ae.active.zenobia hong-member-003f1.ae.active.zenobia hong-jackeline-001k1.ae.active.zenobia hong-jackeline-000r1.ae.active.zenobia hong-jackeline-001e1.ae.active.zenobia hong-jackeline-003f1.ae.active.zenobia hong-ymefvuphccrj-001k1.ae.active.zenobia hong-ymefvuphccrj-000r1.ae.active.zenobia hong-ymefvuphccrj-001e1.ae.active.zenobia hong-ymefvuphccrj-003f1.ae.active.zenobia hong-raymonde-001k1.ae.active.zenobia hong-raymonde-000r1.ae.active.zenobia hong-raymonde-001e1.ae.active.zenobia hong-raymonde-003f1.ae.active.zenobia	Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs
jacquetta@evie.com	AE Member Services - HUI	hui-member-001k1.ae.active.zenobia hui-member-000r1.ae.active.zenobia hui-jackeline-001k1.ae.active.zenobia hui-jackeline-000r1.ae.active.zenobia hui-ymefvuphccrj-001k1.ae.active.zenobia hui-ymefvuphccrj-000r1.ae.active.zenobia hui-raymonde-001k1.ae.active.zenobia hui-raymonde-000r1	Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs Insufficient Logs MgDzvf

And this is how it is going in attachment, as single line which is disturbing my output a lot

Can anyone please advice how to correct it. 

Thanks in advance.

[ITWhisperer]

Is it that you want to replace the spaces with new lines?

Something like this perhaps?

| eval hosts=replace(hosts," ","
")