Blacki Migliozzi blacki

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                blacki
                / keybase.md
            
            
              Last active
              February 21, 2020 19:53
            
              
                keybase.md
              
          
    Keybase proof

I hereby claim:

I am blacki on github.
I am blacki (https://keybase.io/blacki) on keybase.
I have a public key ASBDjIF55sXPuKrqIhcNRGiDZn1PTI_DaCCbmvkrQhi9dgo

To claim this, I am signing this object:

  
## GoogleSheet : export links and texts separately from a rich text
/**
 * Returns the URL of a hyperlinked cell, if it's entered with hyperlink command.
 * Supports ranges
 * @param {A1}  reference Cell reference
 * @customfunction
 */
function linkURL(reference) {
  var sheet = SpreadsheetApp.getActiveSheet();
  var formula = SpreadsheetApp.getActiveRange().getFormula();
  var args = formula.match(/=\w+\((.*)\)/i);

## 538.txt
                              ME
               WI          VT NH
WA ID MT ND MN IL MI    NY MA
OR NV WY SD IA IN OH PA NJ CT RI
CA UT CO NE MO KY WV VA MD DE
   AZ NM KS AR TN NC SC
         OK LA MS AL GA
HI AK    TX             FL
	/**
	* Returns the URL of a hyperlinked cell, if it's entered with hyperlink command.
	* Supports ranges
	* @param {A1} reference Cell reference
	* @customfunction
	*/
	function linkURL(reference) {
	var sheet = SpreadsheetApp.getActiveSheet();
	var formula = SpreadsheetApp.getActiveRange().getFormula();
	var args = formula.match(/=\w+\((.*)\)/i);
	ME
	WI VT NH
	WA ID MT ND MN IL MI NY MA
	OR NV WY SD IA IN OH PA NJ CT RI
	CA UT CO NE MO KY WV VA MD DE
	AZ NM KS AR TN NC SC
	OK LA MS AL GA
	HI AK TX FL