Having problems with a footprint read from a CSV file

[Anonym 53]

I am trying to scrape for Wordpress URLs in Google. Nothing strange about that, but this time I am storing the footprints in a CSV file, that looks like this:

 

 

English,"powered by wordpress" "leave a comment" | "leave a post" | "leave a reply" -"comments off" -"comments are closed" -"You must be logged in to post a comment"

Swedish,(+"Drivs " +"med Wordpress") "Lämna en kommentar" | "Kommentera" | "Lämna ett svar" | "E-postadressen publiceras inte. Obligatoriska fält är märkta" -"Kommentarsfunktionen är stängd" -"Kommentering avstängd"

 

 

 

Well, the thing is that the quotation marks (") won't stay after I have got them into the footprint variable which is done like this:

 

clear table(&wpFootprints)

create table from file("{$special folder("Application")}\\wp-footprints.csv", &wpFootprints)

if($comparison(#wordPressVariant, "=", "Swedish")) {

then {

set(#wpFootprint, $table cell(&wpFootprints, 1, 1), "Global")

}

else {

set(#wpFootprint, $table cell(&wpFootprints, 0, 1), "Global")

}

}

 

 

I have tried to prefix the quotation marks with a "\", but that didn't work, nor did """, nor a mime encoding with %22 as a replacement for the ".

 

 

I reckon you guys/gals probably know this already, so... If you know, please tell me.

[Anonym 53]

Hmmm... I made a work around with saving the quotes as tildes instead and then made a replace inside of the bot. Well, it works, but if any of you have a better solution I'd be glad to see it.

 

Thanks.