Question: I'm a new c# programmer. I'm trying to make a simple c# application which will extract headers from a pdf file(book) if they are in this format :

> 
> 1.1 THE ELECTRICAL/ELECTRONICS INDUSTRY
> 
> 
> 1.2 A BRIEF HISTORY
> 
> 
> 1.3 UNITS OF MEASUREMENT
> 
> 
> 

I'm using the code:

```
string pattern = @"(\d+)(\.)(\d+) ([A-Z]+).([A-Z]+).([A-Z]+).([A-Z]+).([A-Z]+)";
Regex.match(strText,pattern); 

```

which works fine for single line headers but doesn't work for two line/multiline headers. 
Can anyone help please ?

Answer: 
Based on your comments to others answers I believe you are doing a lot of unnecessary export/editing/importing. Let the database do all that work for you!

This works on my test table without all that shucking and jiving. For all rows where the year is 2015 it will insert (in effect copy) the same data but with the year increased by 1:

```
insert into x_test
(select col_a, col_b, col_c, col_d, l_date + 365 from x_test  -- 2016
where to_char(l_date, 'YYYY') = '2015');

```

Add even more years at the same time with unions:

```
insert into x_test
(select col_a, col_b, col_c, col_d, l_date + 365 from x_test  -- 2016
where to_char(l_date, 'YYYY') = '2015')
union
(select col_a, col_b, col_c, col_d, l_date + 730 from x_test  -- 2017
where to_char(l_date, 'YYYY') = '2015');

```
There is no bulk insert. You could insert records from one table into another such as "insert into table (column) select t.column from temp\_table t;"