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

[qikaifu]

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

[ovidiusoft]

Just add it to the URL:

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

[qikaifu]

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]

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]

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]

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]

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!