SelectValue fromTf_njvalues ('3c457a2d-188b-4d99-a822-2968054e1fb8,3c457a2d-188b-4d99-a822-2968054e1fb8')CREATE FUNCTIONTf_njvalues (@P0 varchar(Max)--characters that need to be intercepted) RETURNS @OUT_TABLE TABLE(ValueVARCHAR(Max)) as BEGIN
String.Split ()to use: string[] Ss1 = S.split (new[] {"|:|"}, Stringsplitoptions.none); Ss1[0]: a| B //ss1[1]: c:dThe latter parameter, is whether the flag is automaticallyRemove Emptyof Data. For example:"a| b|:| c:d|
The string. split method has six overload functions:
Program code 1) Public String [] Split (Params char [] separator)
2) Public String [] Split (char [] separator, int count)
3) Public String [] Split (char [] separator, stringsplitoptions
We learned the String.Join function (http://blog.csdn.net/zhvsby/archive/2008/11/28/3404704.aspx) last time, When the String.Split function is used, it is possible to check the usage of the function on the Internet such as the following:#used
Today, while looking at the source code, record the learning of the small knowledge.One, thestring.split method has 6 overloaded functions:1) Public string[] Split (params char[] separator)2) public string[] Split (char[] separator, int count)3)
From Blog Park http://www.cnblogs.com/yugen/archive/2010/08/18/1802781.html1. Delimited by string:Using System.Text.RegularExpressions;String str= "AAAJSBBBJSCCC";String[] Sarray=regex.split (str, "JS", regexoptions.ignorecase);foreach (String i in
The string.split method has 6 overloaded functions:1) Public string[] Split (params char[] separator)2) public string[] Split (char[] separator, int count)3) Public string[] Split (char[] separator, stringsplitoptions options)4) Public string[]
String truncation of C # -- Split,In the previous blog "string truncation of C # -- Substring", we introduced the Substring function, and implemented the name of the institution in "institution name/instructor name/course type/Course name, the
Use the split method to split a string similar to "9580 | 9570 | 9571" and convert string [] to a list using arrays. aslist. The result is as follows:
[9, 5, 8, 0, |, 9, 5, 7, 0, |, 9, 5, 7, 1]
List several key points
First, the Java Doc
Split (String. split method)Public split (delimiter: String, [limit: Number]): ArrayDisconnects the String object from all locations where the specified delimiter parameter appears, splits it into substrings, and returns the substrings in array form.
This article mainly introduces the use of ASP.net string segmentation function, the need for friends can refer to the following Let's take a look at a simple example but its array length is 25 instead of 3. The following approach is to first
Description array Split (string $pattern , string $string [, int $limit ]) This function returns an array of strings, each of which is a string with a case-sensitive regular expression pattern as a substring of the boundary. If limitis set,
Well, recently in a variety of direct code debugging, found that the problem may be a little more, let's write down, this essay may be updated from time to time, because I believe different browser differences between a lot.Directly on the code1
Copy Code code as follows:
-->title: Generating test data
-->author:wufeng4552
-->date:2009-09-21 09:02:08
If object_id (' F_split ') is not null drop function F_split
Go
Create function F_split
(
@s varchar (8000),--string to be split
@
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.