Updating a String retrieved out of a DB

[Marcel Stoop]

Hi

I hope somebody could help me with the following problem.

- In the DB Tabele Class a strimg is saved like: Tom;John;Maria;Clark
- With SQL I have to find out in which class for instance John is
saved ----> This I have maneged, meaning I have got the String
"Tom;John;Maria;Clark" retrieved in a variable say: sNames.
- I now have to update John with the wort "Finished" so that the new string
looks like: "Tom;John Finished;Maria;Clark"

My problem is, how do I extract "John" out of the string
"Tom;John;Maria;Clark", and replace it with "John Finished". It does not
matter if it is a replacing or a deleting of "John" and putting "John
Finished" at the end of the new String.

Thanks for the help

Regards
Marcel

 

[Marcel Stoop]

Sounds great and so easy.
I will try it this evening, and keep you updated

Thanks

 

[Marcel Stoop]

Thanks Tom, it woks fine

 

[Guest]

Hi Marcel,

Glad I could help.


Tom
___________________________________