Bitcoin Forum
December 09, 2016, 11:39:15 PM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: How to use google spreadsheet to get the short/full address with btc.to?  (Read 1080 times)
qikaifu
Full Member
***
Offline Offline

Activity: 168


God creats math and math creats bitcoin.


View Profile
October 07, 2011, 01:28:34 PM
 #1

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

If you see any of my suggestions useful, please donate me. http://btc.to/ec
1481326755
Hero Member
*
Offline Offline

Posts: 1481326755

View Profile Personal Message (Offline)

Ignore
1481326755
Reply with quote  #2

1481326755
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
ovidiusoft
Sr. Member
****
Offline Offline

Activity: 252


View Profile
October 07, 2011, 01:46:08 PM
 #2

Just add it to the URL:

https://btc.to/1 will return 12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E
https://btc.to/12RSkbnhxJ8Q1EoXAUL5ziVFb7kHJWo47E will return 1
qikaifu
Full Member
***
Offline Offline

Activity: 168


God creats math and math creats bitcoin.


View Profile
October 07, 2011, 02:51:02 PM
 #3

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.


If you see any of my suggestions useful, please donate me. http://btc.to/ec
ovidiusoft
Sr. Member
****
Offline Offline

Activity: 252


View Profile
October 07, 2011, 06:35:06 PM
 #4

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
***
Offline Offline

Activity: 168


God creats math and math creats bitcoin.


View Profile
October 08, 2011, 02:32:25 AM
 #5

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.



If you see any of my suggestions useful, please donate me. http://btc.to/ec
ovidiusoft
Sr. Member
****
Offline Offline

Activity: 252


View Profile
October 08, 2011, 11:36:06 AM
 #6

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
***
Offline Offline

Activity: 168


God creats math and math creats bitcoin.


View Profile
October 08, 2011, 03:37:57 PM
 #7

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!

If you see any of my suggestions useful, please donate me. http://btc.to/ec
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!