Delete the last part of the string

Hello everyone!

I have the following problem:

I need to delete the last number after "-" only if it's equal to 301

For example

222-444-301	222-444
222-444-555	222-444-555

Thanks!

Parse

Help

Accepted answers

BenMoss

I'm not sure what is going on with that statement...

This one definitely does.

if
right([input],3) = "301"
then
Left([input],Length([input])-4) 
else [input] 
endif

All comments

BenMoss

trimright([field],"-301")

Ben

Nastya

It doesn't work

input	output
5587-838384-223	5587-838384-22
555-33-331	555

BenMoss

Okay so it looks like the trimright([field],"-301") function was looking for any of the characters in -301 at the end of the string and replacing them with nothing; I thought it would do the entire string only.

Anyway, the second solution I have provided should be adequate!

Always learning!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703