cancel
Showing results for 
Search instead for 
Did you mean: 

Collection field format

SWATHISHETTY_T
Level 2

 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
------------------------------
3 REPLIES 3

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
------------------------------
Regards,
Amlan Sahoo

AndreyKudinov
Level 10
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
MVP
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
------------------------------
Sr Cons at Avanade Brazil