Check to see if the array has an empty cell in the first row. ---------------------------------------- From: "Dan Stein" <[email protected]> Sent: Wednesday, March 26, 2014 5:01 PM To: [email protected] Subject: Re: TeraScript-Talk: Array to comma delimited
Yep that works. Seems to leave a leading comma for some reason. But it does work. -- Dan Stein MSN CPNP On Mar 26, 2014, at 4:33 PM, Bill Downall <[email protected]> wrote:Dan, >From what Robert says, presuming you are in version 6 or 7, all you need is: <@VAR arrayname aprefix="" asuffix="" rprefix="" rsuffix="" cprefix="" csuffix="" csep=","> Bill On Wed, Mar 26, 2014 at 4:27 PM, Dan Stein <[email protected]> wrote: Bev, It already is an array. I need to change it to a comma delimited string so it can be used for a JASON array. So I basically need to remove all that table row stuff and end up with an array that is just comma delimited. I tried I thought this would work Array to Text:<@assign nm$brand_cd value='<@var array="nm$brand" type="text" RSUFFIX=",">'> @@nm$brand_cd but no luck On 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. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
