UltraEdit's help document has two aspects, one is its CHM format document and the other is its official website document. The following two areas can be used:ġ, from the Internet search some of this informationĢ, through the UltraEdit help document to learn This is a piece of normal SQL INSERT statement, it is not very easy to feel quickly.
Increase at the front of each row: INSERT INTO Test (name,email,introduce) VALUES (', in UltraEdit,% is the beginning of the line, the following figure: "Įach field value is separated by one or more tab keys, and the following steps:ġ, the first single quotes, double quotes and other characters removed, this step without regular, simple replacement can be.Ģ, remove the blank line: with regular%++^p replaced with an empty string, in addition, there are ^p$ can also, but in the replacement, ^p$ can only replace one blank line at a time.ģ.
#ULTRAEDIT HELP UPGRADE#
John "sat in May 2004 by the Ministry of Education approved to upgrade to the general undergraduate institutions. The sample data to be pieced together are as follows (copied from Excel and pasted into UltraEdit): A few days ago, there is a need to import data in Excel into the database, originally thought to use the program to read the data in Excel and stored in the database, but a friend of the reminder that the use of editplus or ultraedit such tools to directly piece the data into SQL INSERT statements more easily, Also do not have to write any code, because I use ultraedit, so consider using ultraedit regular expression to do this thing, the following is such a process.Īssuming that the imported table fields: Name,email, introduce, and the data in Excel correspond to the same field, it is worth noting that data in Excel, such as introduce, cannot be wrapped, otherwise the statements will be executed with an error.
0 kommentar(er)
