VB6 - Remove last comma in Textbox

Hi all

I would like to know how i can remove in my Text5 the last comma chowing at the end.

Ex;

If i have the value ; 1,2,3,4,5,6,7,8,

Then, it should remove the last ",".

The final answer would be: 1,2,3,4,5,6,7,8


But if i have the value: 1,2,3,4,5,6,7,8

Then since their is no comma as the last digit in the TextBox, the final answer would stay the same: 1,2,3,4,5,6,7,8

How can i do that?

Thanks
LVL 11
Wilder1626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
This should remove any trailing commas
    Do While Right(Text1.Text, 1) = ","
        Text1.Text = Left(Text1.Text, Len(Text1.Text) - 1)
    Loop

Open in new window

0
 
Wilder1626Author Commented:
HI

This is great. Thanks for your help
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.