help, how to update a cell? (ASP classic)

Example a cell data is ( "W. jessy B., jessy B., jjessy pager, Ljessy" )

My Question:
I want to modify "jessy B." to become "jessy CC." and keep all other info same.

Please do not change "W. jessy B."



Thanks / Regards

 

Your question is not clear.

 

database? web page?

 

Hello,

I am not getting your question. Please elaborate more preciously.

 

just replace(", jessy B.,",", jessy CC.,")

 

find the cell and edit it using row column funda

 

write querey
update tablename set coloumnname='"jessy.cc"' where primary key name=cell key)

 

Another alternative, something like:

Dim CellData = "W. jessy B., jessy B., jjessy pager, Ljessy"
Dim cells() = Split(CellData,", ")
cells(1) = "jessy CC."
CellData = Join(cells, ", ")

Code (markup):

 

this way is right, first convert the string into Array, then replace the value.

 

ur question is not clear what do u want...do u want to update the cell directly in to database or by using querey

 

Thanks I though about Split array too.