How do I get rid of the last character in a string

Lucy · September 29th, 2003, 06:59 AM

Hi there

Please could someone help me with the following:
I am producing results on a page (taken from my database) and separating each item with a comma. The following code is within a loop so that I keep getting results out until the end of the records.

response.write rs_recordsetALL.Fields.Item("Item_No").Value & ", "

This gives me something like:
8EP333, 8EP564, 8EP716,

I would like to remove the last comma from the string (string can be any length, depending on the results found) so that it reads:
8EP333, 8EP564, 8EP716

Can anyone help out?

Thanks in advance

Lucy

pgtips · September 29th, 2003, 07:31 AM

Either
1. use Left(theString, Len(theString) - 1) to remove the comma at the end (although you cannot do this once it has been written to the response object, so you'll have to write the whole thing to a temporary string, then strip the trailing comma, then use Response.Write)
or
2. Write your loop slightly different so you don't end up with a trailing comma, e.g.

Code:

' write the first value outside the loop, without a comma
Response.Write rs_recordsetALL.Fields.Item("Item_No").Value
rs_recordsetALL.MoveNext
Do While Not rs_recordsetALL.EOF
    Response.Write ", " 
    Response.Write rs_recordsetALL.Fields.Item("Item_No").Value
    rs_recordsetALL.MoveNext
Loop

pgtips · September 29th, 2003, 07:39 AM

There's a 3rd alternative, if "Item_No" is the only field in your recordset then you can use the join function to do it for you without any loop:

Code:

Response.Write Join(rs_recordsetALL.GetRows(), ",")

Lucy · September 30th, 2003, 05:33 AM

Thanks for your help - point 2 worked a treat!!

Lucy