Example of input:

> 
> column 1 column 2 column 3 column 4 column 5 
> 
> 
> EE12 2014-05-17 22:05:36.260 2 3 
>  12345678901234567890123456789123456789457908
> 
> 
> 

How the output should look like:

> 
> column 1 column 2 column 3 column 4 column 5 
> 
> 
> EE12 2014-05-17 22:05:36.260 2 3 1234
> 
> 
> EE12 2014-05-17 22:05:36.260 2 3 5678
> 
> 
> 

For column 5 which is the long text, I need to separate the long text into 4 characters each. The longest data length is 10800. For columns 1 to 4 will be remain the same. Every 4 characters, there will be a new row recorded.

I am using SSIS script component to do this. I need help in the C# coding to separate the long text and write into database.

THe method i use to spilt the characters into 4 characters each 

```
public class ScriptMain : UserComponent
{
    public override void Input0_ProcessInputRow(Input0Buffer Row)
    {
        //Regax method to seperated the text into 4 characters each
        var input = Row.value.ToString();       
        var regex = new Regex(@".{4}");
        string result = regex.Replace(input, "$&" + Environment.NewLine);
    }

}

```