The data in the oracle column contains multiple mobile phone numbers separated by commas. How can I separate them ?, Oracle Column
ID NUMBER1 137 xxxx, 138 xxxxExtractedID NUMBER1 137 xxxx1 138 xxxx
create
table
test
(id
int
,
phonevarchar2(200));
insert
into
test
values
(1,
'13811111111,13311111111,13900000000'
);
insertintotestvalues(2,'15811111111,15911111111,18800000000');
select
id,c
from
(
with
t
as
(
select
id,phonec
from
test)
select
id,substr
The first step is to introduce the fileScriptsrc= "Ueditor/ueditor.config.js"type= "Text/javascript"CharSet= "Utf-8">Script>Scriptsrc= "Ueditor/ueditor.all.min.js"type= "Text/javascript"CharSet= "Utf-8">Script>Scriptsrc=".. /jquery.min.js "type= "Text/javascript"CharSet= "Utf-8">Script>Second Step HTML elementScripttype= "Text/plain"ID= "Upload_ue">Script>page to invoke:inputtype= "text"ID= "Picture"name= "Cover" />ahref= "javascript:void (0);"onclick= "upimage ();">Upload imagea>inputtype= "tex
makes it easier for us to perform subsequent operations. If Apache uses "," as the separator, it must be refined. If this specification is followed, we can also directly use the getlist method.
2. Let's discuss the first case. There are three candidates: "+", ";", "and" + ", which are special characters in the URL. If the parameter is a plus sign, it is converted into a space. Therefore, the + sign ";" cannot be used. In W3C specifications, the ";" can be the same as "" and used as a connector
The occasional Delphi program involved in string processing, which has a function similar to the split () function in VB, so I checked some information for a long time, now we will sort out these materials for your convenience.
First, a user compiled a function to implement the function and split.
Unit unit1;
Interface
UsesWindows, messages, sysutils, variants, classes, graphics, controls, forms,Dialogs, stdctrls;
Type userarray = array of string;
TypeTform1 = Class (tform)Edit1: tedit;Button1:
This question is still a little troublesome. If each sentence is saved as a string, it will be difficult to separate words at last. Therefore, I use a struct as a sentence to store words in each sentence separately, which makes the final processing much easier.
# Include
Use cronolog to split Tomcat's Catalina. Out File
Recently, due to work requirements, the Catalina. Out file of Tomcat is constantly expanding, which leads to a smaller disk space edge and difficult to manage. Therefore, we want to use a tool to separate it. I found cronolog online.
The installation process is as follows:Download (Latest Version)
# Wget http://cronolog.org/download/cronolog-1.6.2.tar.gz
2. Extract
# Tar zxvf cronolog-1.6.2.tar.gz
3. G
Compile and install zabbix 3.0 and separate deployment configurationsExperimental System: CentOS 6.6 _ x86_64 prerequisites: Prepare the compiling environment in advance. Both firewall and selinux disable the experiment. Note: There are 4 hosts in this experiment. IP address and role allocation are shown in topology: http://pan.baidu.com/s/1bnnYiMr experiment topology used in the test of mariadb software: 1. Preparation 1. modify the hostname and host
Special usage of Android -- split () to split strings, csplit to separate stringsSplit () split string 1. Differentiation in different environments
Java: The split string cannot be written as split ("$") // $ is the character to be split.Android: The split string must contain brackets ("[$]"). // $ indicates the character to be split.2. Special usage -- Case Study of split () character strings in special characters
1 String str = "abc | dfg"; 2 3
XSLT does not provide a ready-made split method to effectively separate the given query string. However, we can use the substring-before and substring-after functions to achieve the split effect. First look at an application requirement:
Content of the XML document to be formatted
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
XML version = "1.0" encoding = "UTF-8"
?>
Items
>
How to separate wine?One person went out for a dozen drinks at night and met a friend on his way home. It happened that this friend was also going to have a drink.However, there is no excess wine in the restaurant, and at this time, the sky is dark, and other wine companies have been beaten up, friends lookVery worried. So the man decided to give his wine half to him, but his friend had only one and three.Neither of them has a name. How can we evenly
be said that this page is very simple.Assume that the code for getnews. php is as follows:$ News = "News list"; // actually, it should be read from the database.?>The shownesw. PHP code is as follows:Then, the code for listnews. php on this joint page is very simple.Include ('getnews. php'); // get dataInclude ('shownesw. php'); // display data?>SummaryThe PHP tag template system can effectively separate the artist and program, and facilitate the div
Recently, in the group column of Dapeng network, I thought of two methods to implement group members,
The first method is to create a group member database and add a new member to add a piece of data. However, if so, the database data size of the group members will be huge. Assume that each group has 10000 members, if there are 1000 groups, the data volume will reach 10000000,
The second method is to create a database for group members, including the field ID, group ID, and group members. The
Today, I met a friend in the group and asked how to use a separate JavaProgramConnect to the MySQL database. Or any other database. I did not write this during my studies.CodeAre written in eclipse or myeclipse. Copy the jar package from the database to the Lib under the project, and then introduce it.Today, I will write a simple Java file connecting to MySQL using Java. The result shows that the connection fails because the driver jar package cannot
Method for separate login when MariaDB and MySQL coexist
Finally, I completed the login method when MariaDB and MySQL coexist. At that time, I knew that the installation was successful, that is, I could not log on to MariaDB. I would like to share my experiences with you.
Port Number logon method:
1. In CentOS7 Environment
1. Install Mysql5.6.19. After the installation is successful, the port number is 3306.
[Root @ centOS7] # mysql-uroot-h127.0.0.1-P
I do not know the cocos2d-x from the first few versions to create a project with python, anyway, I recently downloaded the cocos2d-x-2.2.1 is to create with python, basically is a sentence to help us get it done, saves us a lot of trouble.
The procedure for creating a windows instance is as follows:
Open the windows command line, open the directory to cocos2d-x-2.2.1 \ cocos2d-x-2.2.1 \ tools \ project-creator, and then directly call create_project.py, it will give you the following prompt:
I w
the resource file we need. 3. Add a resource file to the Delphi unit Copy the generated res resource file to the path of your program, and add a {$R mydll.res after the cell file {$R *DFM} }, the res file is added and the compiled resource file is included in the executable file. If you have more than one resource file, you can also add it by using the same method. Note: If successful, will find that the compiled Exe program size will suddenly increase (the size of the dll file is a
This article describes how to use jquery to separate strings. it involves the skills related to string splitting using the split method in jQuery. For more information, see the following example. Share it with you for your reference. The details are as follows:
I. problems:
The returned data is the string separated by a special character @ sss @ vvv. how can I return it to two IDs?$ ("# A"). text (data)$ ("# B"). text (data)How to make them displa
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.