title: Use Left Function To Static Character
body: <p>Is it possible to use the Left function, or another function if better suited, to left trim the values in a field up to a static character, in this case a dash? There is no set amount of characters leading up to the dash, so the length will be greater or smaller but will always have a dash in the field.</p>
  
  <p>Here's an example of some values that could be in the field:</p>
  
  <p>Test1 - Test1 description</p>
  
  <p>Test1 Test2 - Test1 Test2 description</p>
  
  <p>Test1 Test2 Test3 - Test1 Test2 Test3 description</p>
  
  <p>Test4 - Test4 description</p>
  
  <p>After the trim, the end result of record one would be Test1.</p>