fork download 
  1. getSheetID<-function(URL){
  2.   regmatches(URL, regexpr("/spreadsheets/d/\\K[^/]+", URL, perl=TRUE))[1]
  3. }
  4.  
  5. x <- "https://docs.google.com/spreadsheets/d/crazyLongIDstring/edit"
  6. getSheetID(x)
  7.  
  8.  
Success #stdin #stdout 0.26s 39728KB
comments (?)
stdin 
Standard input is empty
stdout 
[1] "crazyLongIDstring"
https://ideone.com/hmuHJa
language:
R (R 3.5.2)
created:
4 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!