Livecycle Designer array example:
var store=new Array(" ",var storeName= new Array (" ",
"eBike store",
"Let it Ride");
*Every value starts and end with double quotation and comma. In order to insert double quote and comma use for following Excel formula:
=CONCATENATE(CHAR(34),a2,char(34),",",CHAR(34),a3,char(34),",",CHAR(34),a4,char(34),",",CHAR(34),a5,char(34),",",CHAR(34),a6,char(34),",",CHAR(34),a7,char(34),",",CHAR(34),a8,char(34),",",CHAR(34),a9,char(34),",",CHAR(34),a10,char(34),",",CHAR(34),a11,char(34),",",CHAR(34),a12,char(34),",",CHAR(34),a13,char(34),",",CHAR(34),a14,char(34),",",CHAR(34),a15,char(34),",",CHAR(34),a16,char(34),",",CHAR(34),a17,char(34),",",CHAR(34),a18,char(34),",",CHAR(34),a19,char(34))
=CONCATENATE(CHAR(34),b2,char(34),",",CHAR(34),b3,char(34),",",CHAR(34),b4,char(34),",",CHAR(34),b5,char(34),",",CHAR(34),b6,char(34),",",CHAR(34),b7,char(34),",",CHAR(34),b8,char(34),",",CHAR(34),b9,char(34),",",CHAR(34),b10,char(34),",",CHAR(34),b11,char(34),",",CHAR(34),b12,char(34),",",CHAR(34),b13,char(34),",",CHAR(34),b14,char(34),",",CHAR(34),b15,char(34),",",CHAR(34),b16,char(34),",",CHAR(34),b17,char(34),",",CHAR(34),b18,char(34),",",CHAR(34),b19,char(34),",",)
=CONCATENATE(CHAR(34),c2,char(34),",",CHAR(34),c3,char(34),",",CHAR(34),c4,char(34),",",CHAR(34),c5,char(34),",",CHAR(34),c6,char(34),",",CHAR(34),c7,char(34),",",CHAR(34),c8,char(34),",",CHAR(34),c9,char(34),",",CHAR(34),c10,char(34),",",CHAR(34),c11,char(34),",",CHAR(34),c12,char(34),",",CHAR(34),c13,char(34),",",CHAR(34),c14,char(34),",",CHAR(34),c15,char(34),",",CHAR(34),c16,char(34),",",CHAR(34),c17,char(34),",",CHAR(34),c18,char(34),",",CHAR(34),c19,char(34),",",)
=CONCATENATE(CHAR(34),d2,char(34),",",CHAR(34),d3,char(34),",",CHAR(34),d4,char(34),",",CHAR(34),d5,char(34),",",CHAR(34),d6,char(34),",",CHAR(34),d7,char(34),",",CHAR(34),d8,char(34),",",CHAR(34),d9,char(34),",",CHAR(34),d10,char(34),",",CHAR(34),d11,char(34),",",CHAR(34),d12,char(34),",",CHAR(34),d13,char(34),",",CHAR(34),d14,char(34),",",CHAR(34),d15,char(34),",",CHAR(34),d16,char(34),",",CHAR(34),d17,char(34),",",CHAR(34),d18,char(34),",",CHAR(34),d19,char(34),",",)
=CONCATENATE(CHAR(34),e2,char(34),",",CHAR(34),e3,char(34),",",CHAR(34),e4,char(34),",",CHAR(34),e5,char(34),",",CHAR(34),e6,char(34),",",CHAR(34),e7,char(34),",",CHAR(34),e8,char(34),",",CHAR(34),e9,char(34),",",CHAR(34),e10,char(34),",",CHAR(34),e11,char(34),",",CHAR(34),e12,char(34),",",CHAR(34),e13,char(34),",",CHAR(34),e14,char(34),",",CHAR(34),e15,char(34),",",CHAR(34),e16,char(34),",",CHAR(34),e17,char(34),",",CHAR(34),e18,char(34),",",CHAR(34),e19,char(34),",",)
=CONCATENATE(CHAR(34),g2,char(34),",",CHAR(34),g3,char(34),",",CHAR(34),g4,char(34),",",CHAR(34),g5,char(34),",",CHAR(34),g6,char(34),",",CHAR(34),g7,char(34),",",CHAR(34),g8,char(34),",",CHAR(34),g9,char(34),",",CHAR(34),g10,char(34),",",CHAR(34),g11,char(34),",",CHAR(34),g12,char(34),",",CHAR(34),g13,char(34),",",CHAR(34),g14,char(34),",",CHAR(34),g15,char(34),",",CHAR(34),g16,char(34),",",CHAR(34),g17,char(34),",",CHAR(34),g18,char(34),",",CHAR(34),g19,char(34),",",)
=CONCATENATE(CHAR(34),h2,char(34),",",CHAR(34),h3,char(34),",",CHAR(34),h4,char(34),",",CHAR(34),h5,char(34),",",CHAR(34),h6,char(34),",",CHAR(34),h7,char(34),",",CHAR(34),h8,char(34),",",CHAR(34),h9,char(34),",",CHAR(34),h10,char(34),",",CHAR(34),h11,char(34),",",CHAR(34),h12,char(34),",",CHAR(34),h13,char(34),",",CHAR(34),h14,char(34),",",CHAR(34),h15,char(34),",",CHAR(34),h16,char(34),",",CHAR(34),h17,char(34),",",CHAR(34),h18,char(34),",",CHAR(34),h19,char(34),",",)
No comments:
Post a Comment