title: Postgres Parse String with Delimiter
body: <p>Trying to parse a sting using SQL, and have not found any solutions online (apologies, maybe I'm looking for the wrong thing).</p>
  
  <p>I have a string field with a series of numbers I need to pull out and sum. Delimiter is "\r\n".</p>
  
  <p>Example: '\r\n - 1234 somenumbersandtext123 \r\n -5678 sometextmorenumbers123'</p>
  
  <p>So in this example, I want to sum 1234 and 5678.</p>
  
  <p>The stings are all different lengths, and I need to eventually sum the numbers within the string. The string details documents tied to a project, and the numbers represent the size of the file (trying to determine the total file size per project).</p>
  
  <p>Thanks in advance for any guidance.</p>