与MySQL函数SUBSTRING_INDEX()等效的JavaScript [英] JavaScript equivalent of the MySQL function SUBSTRING_INDEX()
本文介绍了与MySQL函数SUBSTRING_INDEX()等效的JavaScript的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SUBSTRING_INDEX() 返回指定次数的定界符之前的字符串中的子字符串.
SUBSTRING_INDEX() in MySQL returns a substring from a string before the specified number of occurrences of the delimiter.
JavaScript中是否有任何等效功能?我需要执行相同的操作..但要对JavaScript中的字符串值执行
Is there any equivalent function in JavaScript? I need to perform the same thing.. but on a string value in JavaScript.
推荐答案
MySQL:
SELECT SUBSTRING_INDEX('www.stackoverflow.com', '.', 1) result;
+--------+
| result |
+--------+
| www |
+--------+
1 row in set (0.00 sec)
SELECT SUBSTRING_INDEX('www.stackoverflow.com', '.', 2) result;
+-------------------+
| result |
+-------------------+
| www.stackoverflow |
+-------------------+
1 row in set (0.00 sec)
JavaScript:
JavaScript:
function substringIndex (input, delimiter, index) {
var arr = input.split(delimiter);
arr.splice(index, arr.length - index);
return arr.join(delimiter);
}
console.log(substringIndex('www.stackoverflow.com', '.', 1));
// www
console.log(substringIndex('www.stackoverflow.com', '.', 2));
// www.stackoverflow
这篇关于与MySQL函数SUBSTRING_INDEX()等效的JavaScript的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文