Robert, RSEP and CSEP are too cool. I totally missed those!
Bill On Wed, Mar 26, 2014 at 4:23 PM, Robert Shubert <[email protected]>wrote: > > 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. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
