ushasharma84
07-19-2011, 04:53 AM
hi
i have a column in which i want to replace certain special characters with some other characters. now the problem is these characters occurs at random position in string so position of characters is not fixed in that column. for example i want to raplace ± symbol in the cell which occurs at many cells in that column at random positiion with ±. because i m importing this excel to xml and in xml these symbols should be entered in other codes. so want some help to read the string character by character and replacing that character.i hope i made myself clear. waiting for reply...............
Thanks in advance
i have a column in which i want to replace certain special characters with some other characters. now the problem is these characters occurs at random position in string so position of characters is not fixed in that column. for example i want to raplace ± symbol in the cell which occurs at many cells in that column at random positiion with ±. because i m importing this excel to xml and in xml these symbols should be entered in other codes. so want some help to read the string character by character and replacing that character.i hope i made myself clear. waiting for reply...............
Thanks in advance