title: crystal reports : substring error
body: <p>I've developed a workaround since crystal reports doesn't seem to have a substring function with the following formula: </p>
  
  <blockquote>
    <p>right({_v_hardware.groupname},
    truncate(instr(replace({_v_hardware.groupname},".",
    ","), ","))</p>
  </blockquote>
  
  <p>What I'm trying to do is search for the period (".") in a string and replace it with a comma.  Then find the comma position in the string and print all characters following after the comma.  This is assuming the string will only have 1 period in the entire string.  </p>
  
  <p>Now when I attempt to do this, I get some weird characters which look like wingdings.  Any ideas? </p>
  
  <p>thanks in advance. </p>