How to use google spreadsheet to get the short/full address with btc.to?

qikaifu

full member

Activity: 168

Merit: 100

God creats math and math creats bitcoin.

Quote from: ovidiusoft on October 08, 2011, 06:36:06 AM

I did understood you question. You asked for the right formula. I figured out you already knew how to load data from a URL and you had problems making out the correct URL. My answer was supposed to suggest that you need to concatenate the URL to the short/full address.

BTW, my solution is:

Code:

=importdata(concat($A$1;B2))

A1="http://btc.to/", A2 and down has the formula and in column B I write the addresses.

Thanks, this $A$1 is cool!

ovidiusoft

sr. member

Activity: 252

Merit: 250

I did understood you question. You asked for the right formula. I figured out you already knew how to load data from a URL and you had problems making out the correct URL. My answer was supposed to suggest that you need to concatenate the URL to the short/full address.

BTW, my solution is:

Code:

=importdata(concat($A$1;B2))

A1="http://btc.to/", A2 and down has the formula and in column B I write the addresses.

qikaifu

full member

Activity: 168

Merit: 100

God creats math and math creats bitcoin.

Quote from: ovidiusoft on October 07, 2011, 01:35:06 PM

You don't understand how to use functions in Google Docs, do you? It is working in Google Spreadsheet.

Also, a little bit of respect towards people shouldn't be bad for your health. Try it some day. No rush.

I've figured it out myself, it should be like this.

Code:


=importDATA("http://btc.to/1")

And you really don't understand the question. Not irrespective at all.

ovidiusoft

sr. member

Activity: 252

Merit: 250

You don't understand how to use functions in Google Docs, do you? It is working in Google Spreadsheet.

Also, a little bit of respect towards people shouldn't be bad for your health. Try it some day. No rush.

qikaifu

full member

Activity: 168

Merit: 100

God creats math and math creats bitcoin.

Quote from: ovidiusoft on October 07, 2011, 08:46:08 AM

Just add it to the URL:

https://btc.to/1 will return 12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E
https://btc.to/12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E will return 1

You don't understand my quesion, do you? It's not working in the Google Spreadsheet.

ovidiusoft

sr. member

Activity: 252

Merit: 250

Just add it to the URL:

https://btc.to/1 will return 12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E
https://btc.to/12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E will return 1

qikaifu

full member

Activity: 168

Merit: 100

God creats math and math creats bitcoin.

Somebody please help and give me the right formula to get the full and short address from btc.to, thanks!

Topic: How to use google spreadsheet to get the short/full address with btc.to? (Read 1286 times)