Ask Your Question
0

Use web tools to process data in calc

asked 2015-01-23 02:19:06 +0200

Noodle gravatar image

updated 2015-01-23 02:32:23 +0200

Hi, I want to take cell strings and use them as a variable in a web address and then return the first result to the next column.

Example

So for example, I didn't have much trouble taking a pile of Japanese words and automatically sorting them into one cell each, removing duplicates, and removing the blank row gaps. But now I want to apply each word into this web search:

http://m.jisho.org/words?jap=[VARIABLE]&eng=&dict=edict&romaji=on

and then print the first result (unique selector: "body > p:nth-child(6)" in firefox development mode) to the next column over. The desired result obviously being a document which automatically takes a pile of japanese words, sorts them, and then provides an english translation from jisho.org .

So for example, for a3 it would search

http://m.jisho.org/words?jap=yusa&eng=&dict=edict&romaji=on

and return the result for yusai, the closest match, and print

油彩 (yusai) Common word, Noun oil painting

to b3.

How do I do this?

Thank you very much for your help, I can't find any information on doing this through searches.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-08-05 01:05:16 +0200

erAck gravatar image

You could experiment with the WEBSERVICE() function, but that returns the entire page so you'll need to use FIND() or SEARCH() on it. If there was a parameter to the URI to return XML instead of HTML you could use FILTERXML() to extract XPath data.

edit flag offensive delete link more

Comments

The issue with FILTERXML() is that it has a pending bug XMLpath in FIlterxml does not work with arrayfunction

m.a.riosv gravatar imagem.a.riosv ( 2016-08-05 01:58:33 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-01-23 02:19:06 +0200

Seen: 171 times

Last updated: Aug 05 '16