Menu
  • HOME
  • TAGS

Extracting numbers from a string in crystal reports 9

crystal-reports,crystal-reports-9

I figured out an answer which would work for this specific case. I used the following conditions in a formula field. Based on the condition I called a User defined function 'Tolerance','Tolerance2', 'Tolerance3'. Formula field: IF (Left ({PDPRINTDATA.PD_T45}, 3 )="+/-") THEN '+/-' + ToText(Tolerance({PDPRINTDATA.PD_T45}),3) ELSE IF (Left ({PDPRINTDATA.PD_T45} , 1...