Add text in middle of the String after a specific character
Hi there,
I have a table which has a column Names, I am saving the data in that column as below,
- Name1<br/>- Name2<br/>- Name3<br/>- Name4<br/>-
- Name1<br/>- Name2<br/>- Name3<br/>-
- Name1<br/>- Name2<br/>-
- Name1<br/>-
Now, the Requirement is when i fetch the data it should append "; and" before the last name
like this
- Name1<br/>- Name2<br/>- Name3; and<br/>- Name4<br/>-
- Name1<br/>- Name2; and<br/>- Name3<br/>-
- Name1; and<br/>- Name2<br/>-
- Name1<br/>-
which will give me out put as
Name1
Name2
Name3; and
Name4
help needed!!!
Thanks in advance
-sadaf
November 11th, 2010 6:23am