{"id":348,"date":"2014-07-10T20:55:51","date_gmt":"2014-07-11T03:55:51","guid":{"rendered":"http:\/\/layneshipley.shipley.website\/?p=348"},"modified":"2014-07-10T20:55:51","modified_gmt":"2014-07-11T03:55:51","slug":"remove-duplicates-list-function","status":"publish","type":"post","link":"https:\/\/layne.eqlik.us\/index.php\/archives\/348","title":{"rendered":"Remove Duplicates from List() function"},"content":{"rendered":"<div>Let ( [<\/div>\n<div><\/div>\n<div>TheValue = LeftValues ( Text ; 1 ) ;<\/div>\n<div>TheCount = ValueCount ( Text ) ;<\/div>\n<div>NewText = Replace ( Substitute ( &#8220;\u00b6&#8221; &amp; Text &amp; &#8220;\u00b6&#8221; ; [ &#8220;\u00b6&#8221; ; &#8220;\u00b6|&#8221; ] ; [ &#8220;|&#8221; &amp; TheValue ; &#8220;&#8221; ] ; [ &#8220;|&#8221; ; &#8220;&#8221; ] ) ; 1 ; 1 ; &#8220;&#8221; )<\/div>\n<div><\/div>\n<div>] ;<\/div>\n<div><\/div>\n<div>\u00a0 \u00a0 \u00a0Case ( TheCount &gt; 0 ;<\/div>\n<div><\/div>\n<div>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TheValue &amp; RemoveDuplicates ( Replace ( NewText ; Length ( NewText ) ; 1 ; &#8220;&#8221; ) )<\/div>\n<div><\/div>\n<div>\u00a0 \u00a0 \u00a0)<\/div>\n<div><\/div>\n<div>)<\/div>\n<div><\/div>\n<div>For more information:\u00a0<a title=\"RemoveDuplicates\" href=\"http:\/\/www.briandunning.com\/cf\/492\" target=\"\">http:\/\/www.briandunning.com\/cf\/492<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Let ( [ TheValue = LeftValues ( Text ; 1 ) ; TheCount = ValueCount ( Text ) ; NewText = Replace ( Substitute ( &#8220;\u00b6&#8221; &amp; Text &amp; &#8220;\u00b6&#8221; ; [ &#8220;\u00b6&#8221; ; &#8220;\u00b6|&#8221; ] ; [ &#8220;|&#8221; &amp; TheValue ; &#8220;&#8221; ] ; [ &#8220;|&#8221; ; &#8220;&#8221; ] ) ; 1 ; 1 ; &#8220;&#8221; ) ] ; \u00a0 \u00a0 \u00a0Case ( TheCount &gt; 0 ; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TheValue &amp; RemoveDuplicates ( Replace ( NewText ; Length ( NewText ) ; 1 ; &#8220;&#8221; ) ) \u00a0 \u00a0 \u00a0) ) For more information:\u00a0http:\/\/www.briandunning.com\/cf\/492<\/p>\n","protected":false},"author":1,"featured_media":346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,6],"tags":[],"class_list":["post-348","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computers","category-filemaker"],"acf":[],"_links":{"self":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/comments?post=348"}],"version-history":[{"count":0,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/posts\/348\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media\/346"}],"wp:attachment":[{"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/media?parent=348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/categories?post=348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/layne.eqlik.us\/index.php\/wp-json\/wp\/v2\/tags?post=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}