Re: [GENERAL] Sorting CSV string and removing Duplicates

2015-07-27 Thread Alex Magnum
Hi Danish, yes thats the one I was looking for. Thanks a lot!!! On Tue, Jul 28, 2015 at 1:32 AM, dinesh kumar wrote: > > > On Mon, Jul 27, 2015 at 12:57 PM, dinesh kumar > wrote: > >> On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum >> wrote: >> >>> Hello, >>> >>> I have a csv string in a text f

Re: [GENERAL] Sorting CSV string and removing Duplicates

2015-07-27 Thread dinesh kumar
On Mon, Jul 27, 2015 at 12:57 PM, dinesh kumar wrote: > On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum > wrote: > >> Hello, >> >> I have a csv string in a text field that is unsorted and contains >> duplicates. >> Is there a simple way to remove these and sort the string. >> >> E.g >> 2,18,20,23,

Re: [GENERAL] Sorting CSV string and removing Duplicates

2015-07-27 Thread Chris Mair
> Hello, > > I have a csv string in a text field that is unsorted and contains > duplicates. > Is there a simple way to remove these and sort the string. > > E.g > 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27 > > i tried string to array and unique but that did not work... > Any suggestions on ho

Re: [GENERAL] Sorting CSV string and removing Duplicates

2015-07-27 Thread Yves Dorfsman
> > I have a csv string in a text field that is unsorted and contains duplicates. > Is there a simple way to remove these and sort the string. > > E.g > 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27 > Do you need to eventually load the data in Postgres? I'd personally use python to deal with th

Re: [GENERAL] Sorting CSV string and removing Duplicates

2015-07-27 Thread dinesh kumar
On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum wrote: > Hello, > > I have a csv string in a text field that is unsorted and contains > duplicates. > Is there a simple way to remove these and sort the string. > > E.g > 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27 > > i tried string to array and uniqu

[GENERAL] Sorting CSV string and removing Duplicates

2015-07-27 Thread Alex Magnum
Hello, I have a csv string in a text field that is unsorted and contains duplicates. Is there a simple way to remove these and sort the string. E.g 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27 i tried string to array and unique but that did not work... Any suggestions on how to do this without wri