Collection field format

[SWATHISHETTY_T]

 I'm  trying to read data from SQL to a collection, but when I get data to a collection, the text format is getting changed.
Eg: When I see the values of text field in a collection, the default format is plain text, without newline or a tab space in it. 
I could see other formats like "Javascript","SQL", and "XML".

Please suggest me how to change it to  other format.

------------------------------
SWATHI SHETTY T
------------------------------

[_Amlansahoo]

Hi Swathi,

It will always appear as text format. So if you want to change it number format then you can change it after reading it.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

[AndreyKudinov]

Plain text/Javascript/SQL/XML formatting doesn't matter - it's just for looks, underlying data is the same regardless of formatting.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

[EmersonF]

By default always return a text collection if for some reason you need a new data structure you will have to do this in the process, for example Collection to Json for example.
XML: JSFiddle - Code Playground

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
------------------------------