Remove data from a String 1

[YANKRAY]

Using CR 10.0

I have a field with part numbers of various lengths.

Some of the Part numbers end with -EA.

I need to be able to remove the -EA from those that have it and leave the remaining part number.

Examples:

Field contains;

12345
1467
5678-EA
89-EA

Result should look like;
12345
1467
5678
89

Thanks,
Ray

 

[fisheromacse]

i do not have crytsal in front of me right now, but perhaps something like this:

IF RIGHT({Table.Field},3)="-EA"
then LEFT({Table.Field},LEN({Table.Field}-3))

 

[lbass]

Or use the following instead of the partno field:

replace({table.partno},"-EA","")

-LB

 

[YANKRAY]

Fisher - Your solution gave me a "must be a number" error from Crystal.

LB - Your solution was exactly what I needed.

Thanks for the support.

Ray