How to remove last comma

[SuvarnaChaudhari]

Hi,I am new to .net.
As per ur guidance I tried myString = myString.SubString(0,myString.Length-1);
I also used str.lastindexof n str.remove,but by using this I m gettin string as ' (B193 '' H13 '' H14 ' ) instead of (' B193 ',' H13 ',' H14' ).My original string is
(' B193 ',' H13 ',' H14 ', )I want to remove last comma.My code is ---

Dim s1, strpid As String
Dim arr(), arr2()
Dim i As Integer
s1 = Request("PatientIDs")
arr = Split(s1, ":")
For i = 0 To UBound(arr)
arr2 = Split(arr(i), ">")
strpid = ("'" & arr2(0) & "'" & ",")
Response.Write(strpid)
Next

Plz reply.

[CyberSoftHari]

myString = myString.SubString(0,myString.Length-1);

This should work. What is the output you are getting?

[SuvarnaChaudhari]

myString = myString.SubString(0,myString.Length-1);

This should work. What is the output you are getting?

I am getting --(' B193 '' H13 '' H14 ' ).this is removing all commas.I want
(' B193 ',' H13 ',' H14 ' )

[CyberSoftHari]

can you post exact code part?(Check where you are using.)

[SuvarnaChaudhari]

can you post exact code part?(Check where you are using.)

I am sending whole code
Dim s1, strpid As String
Dim arr(), arr2()
Dim i, j As Integer
s1 = Request("PatientIDs")
arr = Split(s1, ":")
For i = 0 To UBound(arr)
arr2 = Split(arr(i), ">")
strpid = Trim("'" & arr2(0) & "'" & ",")
j = strpid.LastIndexOf(",")
strpid = strpid.Remove(j, 1)
Response.Write(strpid)
Next
'Query = "select patient_id,patient_name,study_instance_UID from studies where patient_id in " + Trim(strpid) + " "
'show_selected(Query)

I am writing on page load.

[CyberSoftHari]

But there is no

myString = myString.SubString(0,myString.Length-1);

I mean, No

Substring 

keyword

[SuvarnaChaudhari]

But there is no

myString = myString.SubString(0,myString.Length-1);

I mean, No

Substring 

keyword

yes,I m getting str.substring
But it is removing all commas,while I want to remove onle last one.

[SuvarnaChaudhari]

But there is no

myString = myString.SubString(0,myString.Length-1);

I mean, No

Substring 

keyword

I m sorry,First time I did'nt got ur questn.So replying second time.


Dim s1, strpid As String
Dim arr(), arr2()
Dim i, j As Integer
s1 = Request("PatientIDs")
arr = Split(s1, ":")
For i = 0 To UBound(arr)
arr2 = Split(arr(i), ">")
strpid = Trim("'" & arr2(0) & "'" & ",")
strpid = strpid.Substring(0, strpid.Length - 1)
strpid = strpid.Trim(arr2(0))
Response.Write(strpid)
Next

Actually I am trying number of methods.Writing-deleting code again n again.

[CyberSoftHari]

str = str.SubString(0,str.Length-1);
MessageBox.Show(str);

run this code and see the popup message.

Note: Write this code outside for loop.

[SuvarnaChaudhari]

str = str.SubString(0,str.Length-1);
MessageBox.Show(str);

run this code and see the popup message.

Note: Write this code outside for loop.

I am getting selected id one by one.I mean If I select three row it is giving id like
('B193') on clinking ok it gives second id,then third.that is in quotation mark.

[CyberSoftHari]

This seems you never got the concept.
Where you receiving the value “' B193 ',' H13 ',' H14 ',”?
Note: You have to try (Giving the solution to a homework will be a spam here) I pointed that is exactly correct but the thing is where you are applying!) try Survana you can do?... Come..on).

[dip_developer]

Hi,I am new to .net.
As per ur guidance I tried myString = myString.SubString(0,myString.Length-1);
I also used str.lastindexof n str.remove,but by using this I m gettin string as ' (B193 '' H13 '' H14 ' ) instead of (' B193 ',' H13 ',' H14' ).My original string is
(' B193 ',' H13 ',' H14 ', )I want to remove last comma.My code is ---

Dim s1, strpid As String
Dim arr(), arr2()
Dim i As Integer
s1 = Request("PatientIDs")
arr = Split(s1, ":")
For i = 0 To UBound(arr)
arr2 = Split(arr(i), ">")
strpid = ("'" & arr2(0) & "'" & ",")
Response.Write(strpid)
Next

Plz reply.

i was reading your long conversation.....CyberSoft has correctly given you the solution........but if it sounds a bit confusing I am giving you a second method ...you may try it.......hope it will work

[size=2][/size]

 Dim str As String = "' B193 ',' H13 ',' H14 '," 
str = str.TrimEnd(",")
MsgBox(str)
 

[SuvarnaChaudhari]

This seems you never got the concept.
Where you receiving the value “' B193 ',' H13 ',' H14 ',”?
Note: You have to try (Giving the solution to a homework will be a spam here) I pointed that is exactly correct but the thing is where you are applying!) try Survana you can do?... Come..on).

Thanks for ur reply.Finally I got it!

[SuvarnaChaudhari]

i was reading your long conversation.....CyberSoft has correctly given you the solution........but if it sounds a bit confusing I am giving you a second method ...you may try it.......hope it will work

[size=2][/size]

 Dim str As String = "' B193 ',' H13 ',' H14 '," 
str = str.TrimEnd(",")
MsgBox(str)
 

Thaks for ur reply,I got it.