Replace chararcter in dataset (vb)

[Rexxx]

I have a dataset named company and I am trying to replace every character (^) in the rows of a certain column (coname) with another character ('). Code I have is follows:

For i = 0 to ds.Tables.Count -1
Replace(ds.Tables("company&quot.Rows(i).Item("coname&quot, "^", "'&quot
Next

Problem is, this apparently isn't storing the changed items. What do I need to add to get the rows that get changed to stay changed within this dataset company?

 

[Zarcom]

Hey Rexxx when you are doing this the value is not actually being stored. The string in 'coname' with the new character/s is returned by the replace function. If you want the value to be stored in the data set then use that value that is coming out of the replace function.

like this
mystring = replace(mystring, "^", "'&quot
replacing mystring with your dataset row, column combo.

HTH That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[Rexxx]

vb Solution that works:

dim temp as string
For i = 0 to ds.Tables(0).Rows.Count - 1
temp = Replace(ds.Tables("company&quot.Rows(i).Item("coname&quot, "^", "'&quot
ds.Tables("company&quot.Rows(i).item("coname&quot = temp
Next

or table specific

For i = 0 to ds.Tables("partner&quot.Rows.Count - 1
temp = Replace(ds.Tables("partner&quot.Rows(i).Item("oname&quot, "^", "'&quot
ds.Tables("partner&quot.Rows(i).item("oname&quot = temp
Next

 

[Zarcom]

thats what I said.

you can skip the temp bit too.

ds.Tables("partner&quot.Rows(i).item("onName&quot = replace(ds.Tables("partner&quot.Rows(i).item("onName&quot, "^","'&quot That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540