Trimming when comparing two fields

[RichCha]

Hi everyone,

Crystal Version: 10

Here’s what I’m attempting to accomplish. I have two fields {Feature_Code}, {Feature_Value}. I would like to remove the ‘H’ from the {Feature_Value} only if the {Feature_Code} = HOU_067.


How it is now:
{Feature_Code} {Feature_Value}
HOU_065 H12500
HOU_065 H32450
HOU_067 H23465
HOU_067 H23455
HOU_067 H56854
HOU_235 H12343


What I need:
{Feature_Code} {Feature_Value}
HOU_065 H12500
HOU_065 H32450
HOU_067 23465
HOU_067 23455
HOU_067 56854
HOU_235 H12343


Thanks so much,
RichCha

 

[synapsevampire]

Feature Value formula:

if {table.Feature_Code} = "HOU_067" then
mid(table.Feature_Value},2)
else
{table.Feature_Value}

-k

 

[RichCha]

-k

Your example was missing a '{'. I made the change and the formula works great!!! Thanks for all help.


if {table.Feature_Code} = "HOU_067" then
mid({table.Feature_Value},2)
else
{table.Feature_Value}


RichCha