title: tExtractRegexFields Talend, using regex to seperate column into multiple columns by length
body: <p>I have a job that has a column that is unbounded coming from an xml file and the length of the column can exceed more than 4000 characters, however, this is the maximum length of Oracle varchar column. I need to be able to use the <code>tExtractRegexFields</code> component in Talend to separate the columns every 3000-4000 characters into a separate column.</p>
  
  <p>I however, am not good with Regex and am having some trouble.</p>
  
  <p>The text is generally formatted like this:</p>
  
  <pre><code>"&lt;p&gt;#Principal Responsibilities: &lt;/p&gt;
  &lt;p&gt;INSERT EXTREMELY LONG DESCRIPTION HERE&lt;/p&gt;"
  </code></pre>
  
  <p>I tried using something like this:</p>
  
  <pre><code>"([a-zA-Z0-9]{0,4000})" 
  </code></pre>
  
  <p>but I was having no luck, it was only capturing 1 word.</p>
  
  <p>Job is set up like this:</p>
  
  <pre><code>tFileInputXML------&gt;tExtractRegexFields-----&gt;tMap------tOracleOutput
  </code></pre>
  
  <p>I know it is something simple I am missing, but I just cant figure out what!</p>