splitting fields 1

[Ouch]

I have a field on a form like so

One ; two ; three ; four

users sometimes add a extra ;

One ; two ; three ; four ;

i want to delete the last ; but only if it is a ;

Any idea's

 

[pkw25]

Could you try something like

lent = Len(input)

if Right(Input,2)=";;"

then

CleanField = Left(input,lent-1)


Paraic.