Actually looks liker that might be bad data where someone entered a space in a field and nothing else. This does work just fine. -- Dan Stein MSN CPNP Digital Software Solutions [email protected] www.dss-db.com
On Mar 26, 2014, at 5:01 PM, Dan Stein <[email protected]> wrote: > 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.
