Page 1 of 1

Can't replace a character symbol

Posted: Tue Feb 03, 2004 11:18 pm
by cyberdude
I have the following string I am trying to erase for my footers.

n° 66

I have managed to erase the n and 66 but the ° symbol (the degree symbol) is not being picked up by the find.

Any ideas on how I can achieve this?

Thanks

Posted: Wed Feb 04, 2004 8:44 am
by DataMystic Support
The easiest way will be to paste it into an Excel spreadsheet in column 1, and the replacement in column 2.

Then get WordPipe to load this Excel spreadsheet as a search/replace list at run time (ie do NOT load it into the GUI because it does not currently support unicode).

Posted: Thu Feb 05, 2004 8:00 pm
by cyberdude
It didn't work. I entered n° 66 in the first column and nothing in the second column of a spreadsheet like you suggested but it still didn't work. I even tried just the ° on its own but that didn't work either.

Am I missing something here? Using word 2000 on XP Pro

Posted: Fri Feb 06, 2004 8:14 am
by DataMystic Support
Did you use the Excel spreadsheet in the 'Load from file' field? NOT the 'Import Search/Replace list'??

Posted: Sat Feb 07, 2004 7:49 am
by cyberdude
yes.

Posted: Mon Feb 09, 2004 9:41 am
by DataMystic Support
Hmm.

Could you please send me a samle document, your .wpp file and the excel spreadsheet?

Posted: Mon Feb 09, 2004 12:40 pm
by DataMystic Support
The problem is with the degree symbol. Even Word cannot find this text normally, so we have to use some trickery to make it work.

Use this search text:
Rua Castelo dos Governadores, n*66, 8600-563 Lagos, Portugal

But make sure that the Search Type is set to 'Use Wildcards' - here we use the '*' to match the degree symbol.

Posted: Wed Feb 11, 2004 12:46 am
by cyberdude
Thanks. That did it.