String Manipulation

[mark curtis]

I have a string called strEmail as follows:

me.me@comp.co.uk,you.you@comp.co.uk, etc

What I need to do is strip off the comma at the very end of the string.

I have tried left, len and all the rest, can anyone help?

Thanks
Mark

 

[UniqueTII]

Are you trying to populate a new table with the addresses?

One way I can think of to do it would be to set an Integer value to the location of the first comma (using InStr([start],string to search in, string to search for, comparison type)) and then take part to the left of that as the email address and the part to the right as the new strEmail and repeat the process until finished.

 

[The_Doc_Man]

strCur = Trim$(strCur)

loStrLen = Len( strCur )

if Right$( strCur, 1 ) = "," then
strCur = Left$( strCur, loStrLen - 1 )
End If


This will leave all embedded commas alone.

 

[UniqueTII]

Oh...I see...it helps to read the original question well.

Hey, if you ever need to have all of the addresses seperate, I'm glad I could help.

 

[mark curtis]

Thanks both