|
I am working with Crystal 11 release 2. I am working on a report dealing with addresses. The field is a string and the addresses start with numerics. ie, 1205 Elda St. Since this is a public report I am needing to change that 1205 to 1200 Blk Elda St. I have tried a few formulas:
{field} [(InStr ({field}, " ") + 1) To Length ({field})];
//INSTR({field},"")=3
//INSTR(REPLACE({field},CHR(3),"0")) and
REPLACE({field},CHR(4),"0")
These have not worked. Any suggestions?
|