Guys, I have a csv file with 700+ records. Each record has a about 20 fields. In 3/4 of the fields i have text that contains some basic html like <br /><b><p> etc ... Within this text i have just noticed there is lots of umlauts (special characters) ... I need to clean this content and replace the umlauts with the correct numeric value ... For example: ¬ = ¬ I have no programming experience and use notepad++ to edit this text? I think there is just over 100 umlauts? To save myself a really boring job i need to find a way to 'find and replace' automatically? Any suggestions? Thanks
Use notepad++ it's greeat for editing files. search/find in files There you can enter anything and replace it with anything. Keep in mind you can also replace stuff with a "space"
Actually this is quite easy to code. You just need to make a look that search for a specific code and than replace it.
If there are 100 different special codes (an umlaut is the 2 dots over a vowel used in some languages), you'll have to do 100 global search and replace operations if you want to do it without programming. Notepad++ is fine to use for this. (You could open the file in a web browser. If the page shows up right, highlight the whole page, copy and paste it into Notepad (which ignores almost everything but pure ASCII).