Substring

Js substring

// the substring method returns a string out of another string

const str = 'Mozilla';

console.log(str.substring(1, 3));
// expected output: "oz"

console.log(str.substring(2));
// expected output: "zilla"

Source: google.com

Javascript get first 10 characters of string

var str = "Hello world That is reallly neat!";
var res = str.substring(0, 5);//get first 5 chars

Substring

const str = 'Mozilla';

console.log(str.substring(1, 3));
// expected output: "oz"

console.log(str.substring(2));
// expected output: "zilla"

Substring

str.substr(start[, length])

Source: developer.mozilla.org

Substring

var str = "The MEAN stack is MongoDB, Express.js, AngularJS, and Node.js";
str.indexOf('MongoDB') !== -1 // true
str.indexOf('Java') !== -1 //false
str.indexOf('Node', 5) !== -1 //true

Source: attacomsian.com

Substring

/*Delimiter variables, first and second position*/
DECLARE @dfp AS CHAR(1);
DECLARE @dsp AS CHAR(1);
DECLARE @text VARCHAR(MAX);

SET @dfp = ';';
SET @dsp = '@';
SET @text = 'I want you to ;Extract this@ substring for me please.';

SELECT SUBSTRING(@text, (CHARINDEX(@dfp, @text) + 1), (CHARINDEX(@dsp, @text) - 2) - CHARINDEX(@dfp, @text) + Len(@dsp))

Source: tidbytez.com

Similar codes

0 vote320 views1 answer
Mysql get 2nd value in comma separated list
SQL
6 votes306 views1 answer
Oracle trigger after connect
SQL
0 vote348 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote346 views1 answer
Excel vba import data to sql server
SQL
1 vote329 views1 answer
How to update date add hours in postgresql
SQL
0 vote350 views1 answer
Top 3 salary in sql
SQL
1 vote370 views1 answer
Mysql view curren querys
SQL
0 vote324 views1 answer
Char vs varchar2 in sql
SQL
7 votes405 views2 answers
3rd height salary sql
SQL
1 vote323 views2 answers
Mysql insert generate serie
SQL