replace function

ravi_etl · Post by **ravi_etl** » Mon Mar 29, 2010 4:33 pm

Hi, I have a vaue for one of the fields which is coming in as 'abcdef&ghijkl' instead of 'abcdef&ghijkl'
the problem is it is not coming at the fixed place. I need to replace that "&amp" with "&" in that string.

Please help me if anybody has idea on using a right function to resolve this kind of issue...

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Mar 29, 2010 4:41 pm

You could use the parallel Ereplace() function published on DSXchange, but what happens if other placemarkers (for example ' or €) occur?

Maybe a better approach would be to pre-parse the HTML with a parser specifically for that task (or a routine that you write, but why re-invent the wheel?).

chulett · Post by **chulett** » Mon Mar 29, 2010 5:55 pm

Is this XML you are parsing? If so, it should be handling it automatically.