Re: [GENERAL] need substring based on delimiter

2012-08-23 Thread Joe Conway
On 08/23/2012 02:30 PM, Gauthier, Dave wrote: > I want to create a string from the first 3 elements of a csv (for > example). The csv is longer than 3 elements. Example... > > aaa,bbb,ccc,ddd,eee,fff,ggg > > I want the string "aaa,bbb,ccc". select array_to_string ( (

[GENERAL] need substring based on delimiter

2012-08-23 Thread Gauthier, Dave
Hi: I want to create a string from the first 3 elements of a csv (for example). The csv is longer than 3 elements. Example... aaa,bbb,ccc,ddd,eee,fff,ggg I want the string "aaa,bbb,ccc". Tried splitting this to an array (precursor to appending elements 1,2,3), but failed to be able to ref