title: Replace a substring with a project property value in SoapUI groovy script
body: <p>I need to to replace in a query a parameter with a project property value.
  Take this example: </p>
  
  <p><code>select name from subscribers where phonenb = NEW-CREATE.SUBS.phone and homeaddress = NEW-CREATE.SUBS.address</code></p>
  
  <p>I should replace everything that starts with the prefix <code>NEW-CREATE.SUBS.</code>
  with a project property value whose name comes after this prefix. In my example the project property name would be <code>phone</code> </p>
  
  <p>value <code>0712345678</code> could be obtained like this: <code>testRunner.testCase.testSuite.project.getPropertyValue("phone")</code></p>
  
  <p>and address </p>
  
  <p>value <code>England</code> coming from <code>testRunner.testCase.testSuite.project.getPropertyValue("address")</code></p>
  
  <p>So after this replace my new query should look like:</p>
  
  <p><code>select name from subscribers where phonenb = "0712345678" and homeaddress = "England"</code></p>
  
  <p>And this query I would be able to run on the DBConn, first parameter from the file and then store the result.</p>
  
  <p>Can anyone provide me such a groovy code?</p>
  
  <p>Thanks.</p>