snipt

Ctrl+h for KB shortcuts
#34196

Bash

convert delicious tags from space-separated to comma-separated

# delicious decided (out of nowhere) to change its tag separator from whitespace to comma,
# but since it didn't update it's browser plugin, i ended up with messed up multi-word tags
# here's my quick solution to fix that mess :
#
# 1] export all your delicious tags to a html file e.g. delicious.html
# 2] execute the below awk script to the exported file


BEGIN{ FS = "=" }
{
	i = 1;
	while( i <= NF ) {
		if( $i ~ /TAGS/ ) {
			printf( "%s%s", $i, FS )

			n = split( $(i + 1), a, "\"" )
			
			# the second element of the split array should contain the tags
			gsub( " ", ",", a[ 2 ] )
			
			# print the comma separated tags
			printf( "\"%s\"", a[ 2 ] )
			
			# reconstruct the rest of split array along with the split character
			# do not add the split character after the last element of the array
			for( j = 3; j <= n; j++ ) {
				printf( "%s%s", a[ j ], ( j != n ) ? "\"" : "" )
			}

			# skip the next record since we have just processed it
			i++
		}
		else {
			# if it's the last field do not use FS
			printf( "%s%s", $i, ( i != NF ) ? FS : "" )
		}
		
		i++
	}

	printf( "%s", ORS )
}
https://snipt.net/embed/bd2bd5b9d66596e3dbacdc3e9636614e/
https://snipt.net/raw/bd2bd5b9d66596e3dbacdc3e9636614e/
bd2bd5b9d66596e3dbacdc3e9636614e
bash
Bash
43
2014-04-20T14:29:38
True
False
/api/public/snipt/34196/
convert-delicious-tag-from-space-separated-to-comma-separated
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a> <a href="#L-26">26</a> <a href="#L-27">27</a> <a href="#L-28">28</a> <a href="#L-29">29</a> <a href="#L-30">30</a> <a href="#L-31">31</a> <a href="#L-32">32</a> <a href="#L-33">33</a> <a href="#L-34">34</a> <a href="#L-35">35</a> <a href="#L-36">36</a> <a href="#L-37">37</a> <a href="#L-38">38</a> <a href="#L-39">39</a> <a href="#L-40">40</a> <a href="#L-41">41</a> <a href="#L-42">42</a></pre></div></td><td class="code"><div class="highlight"><pre><span id="L-1"><a name="L-1"></a><span class="c"># delicious decided (out of nowhere) to change its tag separator from whitespace to comma,</span> </span><span id="L-2"><a name="L-2"></a><span class="c"># but since it didn&#39;t update it&#39;s browser plugin, i ended up with messed up multi-word tags</span> </span><span id="L-3"><a name="L-3"></a><span class="c"># here&#39;s my quick solution to fix that mess :</span> </span><span id="L-4"><a name="L-4"></a><span class="c">#</span> </span><span id="L-5"><a name="L-5"></a><span class="c"># 1] export all your delicious tags to a html file e.g. delicious.html</span> </span><span id="L-6"><a name="L-6"></a><span class="c"># 2] execute the below awk script to the exported file</span> </span><span id="L-7"><a name="L-7"></a> </span><span id="L-8"><a name="L-8"></a> </span><span id="L-9"><a name="L-9"></a>BEGIN<span class="o">{</span> <span class="nv">FS</span> <span class="o">=</span> <span class="s2">&quot;=&quot;</span> <span class="o">}</span> </span><span id="L-10"><a name="L-10"></a><span class="o">{</span> </span><span id="L-11"><a name="L-11"></a> <span class="nv">i</span> <span class="o">=</span> 1<span class="p">;</span> </span><span id="L-12"><a name="L-12"></a> <span class="k">while</span><span class="o">(</span> i &lt;<span class="o">=</span> NF <span class="o">)</span> <span class="o">{</span> </span><span id="L-13"><a name="L-13"></a> <span class="k">if</span><span class="o">(</span> <span class="nv">$i</span> ~ /TAGS/ <span class="o">)</span> <span class="o">{</span> </span><span id="L-14"><a name="L-14"></a> <span class="nb">printf</span><span class="o">(</span> <span class="s2">&quot;%s%s&quot;</span>, <span class="nv">$i</span>, FS <span class="o">)</span> </span><span id="L-15"><a name="L-15"></a> </span><span id="L-16"><a name="L-16"></a> <span class="nv">n</span> <span class="o">=</span> split<span class="o">(</span> <span class="k">$(</span>i + 1<span class="k">)</span>, a, <span class="s2">&quot;\&quot;&quot;</span> <span class="o">)</span> </span><span id="L-17"><a name="L-17"></a> </span><span id="L-18"><a name="L-18"></a> <span class="c"># the second element of the split array should contain the tags</span> </span><span id="L-19"><a name="L-19"></a> gsub<span class="o">(</span> <span class="s2">&quot; &quot;</span>, <span class="s2">&quot;,&quot;</span>, a<span class="o">[</span> 2 <span class="o">]</span> <span class="o">)</span> </span><span id="L-20"><a name="L-20"></a> </span><span id="L-21"><a name="L-21"></a> <span class="c"># print the comma separated tags</span> </span><span id="L-22"><a name="L-22"></a> <span class="nb">printf</span><span class="o">(</span> <span class="s2">&quot;\&quot;%s\&quot;&quot;</span>, a<span class="o">[</span> 2 <span class="o">]</span> <span class="o">)</span> </span><span id="L-23"><a name="L-23"></a> </span><span id="L-24"><a name="L-24"></a> <span class="c"># reconstruct the rest of split array along with the split character</span> </span><span id="L-25"><a name="L-25"></a> <span class="c"># do not add the split character after the last element of the array</span> </span><span id="L-26"><a name="L-26"></a> <span class="k">for</span><span class="o">(</span> <span class="nv">j</span> <span class="o">=</span> 3<span class="p">;</span> j &lt;<span class="o">=</span> n<span class="p">;</span> j++ <span class="o">)</span> <span class="o">{</span> </span><span id="L-27"><a name="L-27"></a> <span class="nb">printf</span><span class="o">(</span> <span class="s2">&quot;%s%s&quot;</span>, a<span class="o">[</span> j <span class="o">]</span>, <span class="o">(</span> j !<span class="o">=</span> n <span class="o">)</span> ? <span class="s2">&quot;\&quot;&quot;</span> : <span class="s2">&quot;&quot;</span> <span class="o">)</span> </span><span id="L-28"><a name="L-28"></a> <span class="o">}</span> </span><span id="L-29"><a name="L-29"></a> </span><span id="L-30"><a name="L-30"></a> <span class="c"># skip the next record since we have just processed it</span> </span><span id="L-31"><a name="L-31"></a> i++ </span><span id="L-32"><a name="L-32"></a> <span class="o">}</span> </span><span id="L-33"><a name="L-33"></a> <span class="k">else</span> <span class="o">{</span> </span><span id="L-34"><a name="L-34"></a> <span class="c"># if it&#39;s the last field do not use FS</span> </span><span id="L-35"><a name="L-35"></a> <span class="nb">printf</span><span class="o">(</span> <span class="s2">&quot;%s%s&quot;</span>, <span class="nv">$i</span>, <span class="o">(</span> i !<span class="o">=</span> NF <span class="o">)</span> ? FS : <span class="s2">&quot;&quot;</span> <span class="o">)</span> </span><span id="L-36"><a name="L-36"></a> <span class="o">}</span> </span><span id="L-37"><a name="L-37"></a> </span><span id="L-38"><a name="L-38"></a> i++ </span><span id="L-39"><a name="L-39"></a> <span class="o">}</span> </span><span id="L-40"><a name="L-40"></a> </span><span id="L-41"><a name="L-41"></a> <span class="nb">printf</span><span class="o">(</span> <span class="s2">&quot;%s&quot;</span>, ORS <span class="o">)</span> </span><span id="L-42"><a name="L-42"></a><span class="o">}</span> </span></pre></div> </td></tr></table>
awk, bash, bookmark, delicious, html