topic RE: Collection field format in University Forum

Collection field format

SWATHISHETTY_T — Mon, 17 May 2021 04:00:00 GMT

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

RE: Collection field format

_Amlansahoo — Mon, 17 May 2021 04:44:00 GMT

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

RE: Collection field format

AndreyKudinov — Wed, 19 May 2021 05:04:00 GMT

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

RE: Collection field format

EmersonF — Wed, 19 May 2021 14:25:00 GMT

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