House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / Regular Expressions (RegEx)

Regex for DDL

Author:
Craig Boyd
11/05/2010 09:30 AM

Chris, Thanks for such a quick response!  I will give this a shot! Sincerely, Craigbert ________________________________ Sent: Friday, November 05, 2010 8:24 AM To: cf-regex@houseoffusion.com; Craig Boyd Subject: Re: Regex for DDL assuming that the entire string including carriage returns is being looked at, this should solve your problem. the [\r\n]* is important because it captures both unix linebreaks and windows linebreaks if they exist. /create table\s+(.*?)[\r\n]*\(/ good luck! -Chris Hello All, I can do basic regex, but this one has me stumped.  I need to extract the table name from a DDL statement.  Generally, when creating a table the statement looks like this: CREATE TABLE CUSTOMER ( FLD1... ); The problem I am having is that sometimes the open paren is on the next line down.  It varies from tool to tool how this stuff is formatted. How do I pull out the table name, in this case CUSTOMER, no matter where the open paren is? Thanks, Craigbert </pre><font face="monospace"size="-3"><br>The information transmitted is intended only for the person or entity to which it is addressed and <br>may contain confidential and/or privileged material.  If the reader of this message is not the intended<br>recipient, you are hereby notified that your access is unauthorized, and any review, dissemination,<br>distribution or copying of this message including any attachments is strictly prohibited.   If you are not<br>the intended recipient, please contact the sender and delete the material from any computer.<br><pre>


Search regex

April 23, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30       

Designer, Developer and mobile workflow conference