Archive

Posts Tagged ‘string’

Split string in oracle sql query

August 1, 2016 Leave a comment

select regexp_substr('MyString,otherString,lastOneStr','[^,]+', 1, 2) from dual; 
-- Returns 'otherString' String
Advertisements
Categories: Beyond, Mini-tips, Oracle, plsql, SQL, Tips

Replace commas on string JavaScript

June 14, 2016 Leave a comment

var mystring = "This is a string, with commas, or, is it?";
var result = mystring.replace(/,/g , "|");

Categories: Beyond, JavaScript, Mini-tips