replace all special characters with its html entity in single shot.
Hi, I have an xml file and i have created 100 coumns corresponding to each attributes in xml. Now, i want to search all special characters and replace it with its corresponding html entity in one shot.
But, i don't want to search each character in one column repeatedly..
something like this:-- search pattern is : "[\\>\\-\\.\\^]" replace pattern is : "\\>\\–\\·\\ˆ" so, i want if column contains ">", it replaces it with only ">" not with whole replace pattern..
Re: replace all special characters with its html entity in single shot.
Is there a specific need to use a single regex pattern for the replacement? I did this same procedure by simply using the tReplace component. Just configure the input column, type in the needed html special character and the entity for the replacement. Like Column 1 - < - < etc.