fork download 
  1. re = /(select).*?(from)[\\r\\n]*/i
  2. str = 'SELECT\\r\\n money\\r\\nFROM\\r\\n accounts'
  3. subst = '\\1 count(*) \\2'
  4.  
  5. result = str.gsub(re, subst)
  6.  
  7. # Print the result of the substitution
  8. puts result
  9.  
Success #stdin #stdout 0.01s 5860KB
comments (?)
stdin 
Standard input is empty
stdout 
SELECT count(*) FROM accounts
https://ideone.com/Fe0fVf
language:
Ruby (ruby 2.5.5)
created:
7 years ago
visibility:
public

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!