Remove trailing semi-colon from string

I am having a brain cramp and need some assistance!  Am using Access 2003, and am trying to remove a trailing ";" from a string array of values in a field,
I.E.  field value is E;T;P;
I need to remove the last ";".

Thanks in advance!

ptslv
ptslvAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:

fieldName=left([fieldname],len([fieldName]-1)
0
 
Patrick MatthewsConnect With a Mentor Commented:
Checking to see if the last semicolon is there:

IIf(Right([SomeField], 1) = ";", Left([SomeField], Len([SomeField]) - 1), [SomeField])
0
 
ptslvAuthor Commented:
Thank you so much for the quick response!

ptslv
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Patrick MatthewsCommented:
ptslv,

Are you positive that semicolon will *always* be there?

Regards,

Patrick
0
 
ptslvAuthor Commented:
No, it will not always be there.  I have to look for it.  I just couldn't remember the line to remove it!  I knew it invloved the string length, but couldn't get it set up properly.  Thanks again.

ptslv
0
 
Patrick MatthewsCommented:
ptslv said:
>>No, it will not always be there.  I have to look for it.  

Then you accepted the wrong answer.
0
 
ptslvAuthor Commented:
Patrick,
I'm sorry.  I did not see your response before submitting my acceptance.  It must have come in as I was typing.  I realize now that your response is the correct overall response, but I was looking specifically for the code that capricorn1 submitted in response to my question.  I already had the rest of the code.

ptslv
0
 
Patrick MatthewsCommented:
You can post a request in Community Support to have the question reopened.  Happens
frequently, actually.

BTW, I would have no objection to a split with cap1.
0
 
ptslvAuthor Commented:
OK, I will do that then.  Thanks.

ptslv
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.