Joined: 09 Jul 2015
Location: United States
Online Status: Offline
Posts: 4
Topic: Altering Numerics Posted: 29 Sep 2015 at 4:27am
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")
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum