• Post Reply Bookmark Topic Watch Topic
  • New Topic

finding line number using regex expression  RSS feed

 
Ranch Hand
Posts: 61
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,

My requirement is to find the long raw word from only CREATE TABLE section ONLY.It should not check for PROCUDERE, CREATE VIEW etc blocks even they contain long raw word also.
Please help me how to form regular expression to capture CREATE TABLE block and to find the line number of line that contains long raw.

 
Bartender
Posts: 3271
82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by "long raw word" and why does it have to be done with a regex?
 
Author and all-around good cowpoke
Rancher
Posts: 13078
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you have so far?

Can you read the text file line by line so you can track line numbers?

If so then you are ready to try to recognize whatever "long raw word", CRATE TABLE, etc character sequences.

If not, better concentrate on reading the text and tracking line numbers first.

Bill

 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!