fork download
copy 
  1. my_string = "esrhjg erguhg rziughrtPARTITIONED BY hzueirghf zreeuifh iuehg reuhg riutghSTORED ASiugh oer hfz"
  2. sub("PARTITIONED BY.*STORED AS", "PARTITIONED BY -TO_REPLACE- STORED AS", my_string)
  3. ## or with backreferences:
  4. sub("(PARTITIONED BY).*(STORED AS)", "\\1 -TO_REPLACE- \\2", my_string)
Success #stdin #stdout 0.45s 79168KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
[1] "esrhjg erguhg rziughrtPARTITIONED BY -TO_REPLACE- STORED ASiugh oer hfz"
[1] "esrhjg erguhg rziughrtPARTITIONED BY -TO_REPLACE- STORED ASiugh oer hfz"
https://ideone.com/n7poj9
language:
R (R 3.5.2)
created:
9 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!