G
Gunnar Johansson
Hi,
I have a table (in txt or imported in excel or ms access) with visitors of a
web site and there I get the search
strings if they come to this website directly from a query thorugh google,
altavista, msn etc. I want to have their search words clearly written in the
column.
Now there is difficult to see what it is because there is signs before and
after the words and also UTF translations from language-specific signs.
Is there a easy way to convert this? I found a intresting article
about this made by a Gerry Pattersson, but unfortunately it was pearl he
made it with. Look: http://www.pgts.com.au/pgtsj/pgtsj0307a.html
Is that the only approach? To recognise and translate prat by part and
serch engine by serch engine? No "UTF object" and "Convert method"....?-)
Here are som examples:
1# Google " translate search string ":
http://www.google.se/search?hl=sv&ie=UTF-8&q=translate+google+search+string+queries&meta=2# with swedish signs added " translate search string å ä ö " :http://www.google.se/search?hl=sv&ie=UTF-8&q=translate+search+string+å+ä+ö&meta=3 # The same from altavista " translate search string å äö ":http://se.altavista.com/web/results...å+ä+ö&kgs=1&kls=1Suggestions?RegardsGunnarAOL seem to convert it to a random sign string instead...Regards,Gunnar
I have a table (in txt or imported in excel or ms access) with visitors of a
web site and there I get the search
strings if they come to this website directly from a query thorugh google,
altavista, msn etc. I want to have their search words clearly written in the
column.
Now there is difficult to see what it is because there is signs before and
after the words and also UTF translations from language-specific signs.
Is there a easy way to convert this? I found a intresting article
about this made by a Gerry Pattersson, but unfortunately it was pearl he
made it with. Look: http://www.pgts.com.au/pgtsj/pgtsj0307a.html
Is that the only approach? To recognise and translate prat by part and
serch engine by serch engine? No "UTF object" and "Convert method"....?-)
Here are som examples:
1# Google " translate search string ":
http://www.google.se/search?hl=sv&ie=UTF-8&q=translate+google+search+string+queries&meta=2# with swedish signs added " translate search string å ä ö " :http://www.google.se/search?hl=sv&ie=UTF-8&q=translate+search+string+å+ä+ö&meta=3 # The same from altavista " translate search string å äö ":http://se.altavista.com/web/results...å+ä+ö&kgs=1&kls=1Suggestions?RegardsGunnarAOL seem to convert it to a random sign string instead...Regards,Gunnar