process ma.gnolia_bookmarks for Diigo so that multiwords tags are preserved

jeunium · #1 (**permalink**) 02-08-2009

Hi everyone.

I was lucky enough to backup all my bookmarks last xmas before the
recent complete meltdown of ma.gnolia.com

Unfortunately, when submitting the file to my new diigo account, all
multiword tags are converted to multiple single word tags which is not very
helpful for anyone searching through my tags.

Now I'm wondering how I can process the html file that contains
the bookmarks I managed to salvage (6500) using a combination
of akw and sed I suppose so I can adapt
the inner metadata as to preserve the tags integrity during the import into diigo.

Here is a sample of what the file contains:

Code:

<dt><A HREF="http://max.jsrhost.com/ajaxify/demo.php"
ADD_DATE="1230944239" LAST_MODIFIED="1230944239" 
TAGS="jquery, ajax, web devel tools">Ajaxify - jQuery plugin</A></dt>
<dd>Ajaxify is a jquery plugin that manage your ajax request</dd>

Using the previous code example, in TAGS="(.*?)"

I need to replace the strings of 2 caracters: comma space
with a single comma.
Code:
```
TAGS="jquery, ajax, web devel tools"
```
becomes
Code:
```
TAGS="jquery,ajax,web devel tools"
```
Then, in the same field, replace the remaning spaces with the underscore caracter.
Code:
```
TAGS="jquery,ajax,web devel tools"
```
becomes
Code:
```
TAGS="jquery,ajax,web_devel_tools"
```

How would I do this using my linux shell?
I'd the like to share my findings with my fellow ma.gnoliers

Many thanks in advance

Jeunium
___________________________________
Amanita Muscaria
Is a man eater that must scare ya

danmero · #2 (**permalink**) 02-08-2009

Try sed:

Code:

sed 's/, /,/g' file > newfile

jeunium · #3 (**permalink**) 02-08-2009

Thanks for your answer danmero but wouldn't this do the replacement in all the file?

I want the replacements to occur only within the TAGS tag of each hyperlinks of my input file.

Thanks again for your time danmero

Jeunium
___________________________________
Amanita Muscaria
Is a man eater that must scare ya

danmero · #4 (**permalink**) 02-08-2009

Sorry , I overseen the second requirement

, try awk:

Code:

awk '{FS=OFS="\"";gsub(", ",","$2);gsub(" ","_",$2)}1' file > newfile

jeunium · #5 (**permalink**) 02-08-2009

You are very generous denmero

I greatly appreciate your time and efforts on this but,

Where, in your command does it

limit the "search and replace" to only the TAGS=",,,,," part?

Code:

<dt><A HREF="http://max.jsrhost.com/ajaxify/demo.php"
ADD_DATE="1230944239" LAST_MODIFIED="1230944239" 
TAGS="jquery, ajax, web devel tools">Ajaxify - jQuery plugin</A></dt>
<dd>Ajaxify is a jquery plugin that manage your ajax request</dd>

Jeunium
___________________________________
Amanita Muscaria
Is a man eater that must scare ya

danmero · #6 (**permalink**) 02-08-2009

Code:

awk  '{FS=OFS="\""}/TAGS/{gsub(", ",",",$2);gsub(" ","_",$2)}1' file > newfile

jeunium · #7 (**permalink**) 02-09-2009

I think we're on to something here but it doesn't quite work yet.

Quote:

<A HREF="http://cssjuice.com/13-online-generators-for-web-20-design/" ADD_DATE="1186424504" LAST_MODIFIED="1186424477"
TAGS="web devel tools, online generators">CSS Juice - Design, Tutorial, Showcase and more » 13 Online Generators for Web 2.0 Design</A>

becomes

Code:

<A HREF="http://cssjuice.com/13-online-generators-for-web-20-design/" 
ADD_DATE="1186424504" LAST_MODIFIED="1186424477" 
TAGS="web devel tools,http://cssjuice.com/13-online-generators-for-web-20-design/online generators">
CSS Juice - Design,http://cssjuice.com/13-online-generators-for-web-20-design/Tutorial,
http://cssjuice.com/13-online-generators-for-web-20-design/Showcase and more » 13 Online Generators for Web 2.0 Design</A>

Let's remember that both substitutions must occur within the same

Quote:

TAGS="web devel tools, online generators"

which in this case should become

Quote:

TAGS="web_devel_tools,online_generators"

The substitions must occur ONLY within the TAGS="...." AND NOT on the whole line !!!

Thanks again danmero for your time.

Jeunium
___________________________________
Amanita Muscaria
Is a man eater that must scare ya

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to get data from xml files tags(from data tags)	pvr_satya	Shell Programming and Scripting	9	08-16-2008 09:19 AM
Why are the xml tags not visible?	photon	Shell Programming and Scripting	1	04-06-2007 08:00 AM
Grep xml tags	handak9	Shell Programming and Scripting	9	07-22-2005 02:51 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: