Thanks for the reply..it worked out for me. "Kingsly, John" <[EMAIL PROTECTED]> wrote:Hi
This is a common coding error but very difficult to find. U have to do like this strRow = Left(strRow, Len(strRow) - 1) You are removing the last character but strRow was still holding the old value..that was the problem.. Cheers Kings -----Original Message----- From: Ramakanth Paladi [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 5:43 PM To: aspgroup; aspgroup Subject: [AspNetAnyQuestionIsOk] to remove last character from string hi all, i want to remove last character from the string. i tried different string options like Left(strRow, Len(strRow) - 1) , but i'm not getting, can anybody help me out. the code is as below: For intRow = 1 To 15 strRow = "" For intCell = 1 To 6 strRow = strRow + (objRange.Cells(intRow, intCell).value).ToString + "," Next intCell Left(strRow, Len(strRow) - 1) Next intRow there is a extra ',' (comma) at the end, i want to eliminate it. or do u have any other suggestions...please help __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
