In TS 6.1.1 we added RSEP and CSEP to help with this kind of conversion. Also, you need to pass type=text to convert an array to text on assignment:
<@ASSIGN array <@ARRAY value="red;blue;green">> <@ASSIGN arrayAsString <@VAR array aprefix='' asuffix='' rprefix='' rsuffix='' cprefix='' csuffix='' rsep=',' type=text>> Robert ---------------------------------------- From: "Bill Downall" <[email protected]> Sent: Wednesday, March 26, 2014 4:04 PM To: [email protected] Subject: Re: TeraScript-Talk: Array to comma delimited How about: <@VAR arrayname aprefix="" asuffix="" rprefix="" rsuffix="" cprefix="" csuffix=","> Then you have to remove the last comma, though. <@assign request$mystring='<@VAR arrayname aprefix="" asuffix="" rprefix="" rsuffix="" cprefix="" csuffix=",">'> <@assign request$mystring=<@left str='@@request$mystring' numchars='<@calc "<@length '@@request$mystring'> - 1">'> Bill On Wed, Mar 26, 2014 at 3:54 PM, BEVERLY VOTH <[email protected]> wrote: will @TOKENIZE do ok? if you supply the "delimiter" of return, it should make a real array, which can be further processed. or @REPLACE to substitute one str for another On 26 Mar 2014, at 3:33 PM, Dan Stein wrote: > Brain freeze today. > Need to convert a single column array to comma delimited > > So > Blue > Gren > Red > > to > Blue,Green,Red > > Can't remember how > -- > Dan Stein MSN CPNP > Digital Software Solutions > [email protected] > www.dss-db.com > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
