質問する

Noodle's profile - activity

2016-08-05 05:25:32 +0200 バッジを受け取った  有名な質問 (source)
2016-05-30 17:53:18 +0200 バッジを受け取った  卓越した質問 (source)
2016-05-03 18:05:27 +0200 バッジを受け取った  体系学者
2015-02-01 11:03:41 +0200 バッジを受け取った  人気の質問 (source)
2015-01-23 02:21:29 +0200 バッジを受け取った  編集者 (source)
2015-01-23 02:19:06 +0200 質問をする Use web tools to process data in calc

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.