title: Split text SQL text
body: <p>I'm working on a small project but hit a small obstacle.</p>
  
  <p>So I'm currently able to sent/receive text messages and store them into a database.
  Now i'm working on a trigger, but I'm quite stuck on something.</p>
  
  <p>The text arrives in the table inbox and the information i need is in the column: textdecoded. The text is always something like: </p>
  
  <p>1 stop 5
  (int as ID, start/stop, int)</p>
  
  <p>Now my question is, </p>
  
  <p>how do I define a function that splits this record and places the ID in action.id, the start/stop in action.action and the last int into action.time (note: action.time is defined as an int not as a time))</p>
  
  <p>Thanks in advance everybody :)
  Kind regards,
  David</p>