Title: How to use google spreadsheet to get the short/full address with btc.to? Post by: qikaifu on October 07, 2011, 01:28:34 PM Somebody please help and give me the right formula to get the full and short address from btc.to, thanks!
Title: Re: How to use google spreadsheet to get the short/full address with btc.to? Post by: ovidiusoft on October 07, 2011, 01:46:08 PM Just add it to the URL:
https://btc.to/1 will return 12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E https://btc.to/12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E will return 1 Title: Re: How to use google spreadsheet to get the short/full address with btc.to? Post by: qikaifu on October 07, 2011, 02:51:02 PM 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. Title: Re: How to use google spreadsheet to get the short/full address with btc.to? Post by: ovidiusoft on October 07, 2011, 06: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. Title: Re: How to use google spreadsheet to get the short/full address with btc.to? Post by: qikaifu on October 08, 2011, 02:32:25 AM 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:
And you really don't understand the question. Not irrespective at all. Title: Re: How to use google spreadsheet to get the short/full address with btc.to? Post by: ovidiusoft on October 08, 2011, 11: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. Title: Re: How to use google spreadsheet to get the short/full address with btc.to? Post by: qikaifu on October 08, 2011, 03:37:57 PM 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! |