re = /^(\w+)(-odbc)?:\/\/([\w-][\w.-]*)(?::([a-zA-Z0-9]*))?(?:\/(\w[\w.-]*)\?([\w\\.#-]*)'&'([\w\\!.#-]*))?$/m
str = 'mssql-odbc://sct-mssql-db.c6p0dl1fqnlk.us-east-1.rds.amazonaws.com:1433/sct_mssql_db?mssql_user\'&\'schemaconversion
'
# Print the match result
str.scan(re) do |match|
puts match.to_s
end
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Ruby, please visit: http://ruby-doc.org/core-2.2.0/Regexp.html