Unknown Symbol

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ricki Miles - 16 Jun 2006 21:25 GMT

I am working in Word 2003. I have exported information from a MAC program
called FileMaker into Word tables. It works well except that every time the
MAC created a new line, the Word file contains a square box which I need to
replace with a dash or a comma. I am trying to use Find and Replace but the
symbol is not recognized. I tried copying and pasting the box into the Find
dialog box, but it show nothing. Is there some way for me to be able to
recognize the box in order to use it in Find and Replace?

TIA,

Ricki

Reply to this Message

<*(((><{ - 16 Jun 2006 21:48 GMT

Can you save a copy of your FM file, and replace all the paragraph
marks or line ending codes with "LINEEND" and then export? Then do a
Find/Replace in Word to change LINEEND to ^l or ^p as you choose.

<*((((><{
Fishy@Ocean.Net

In the last exciting episode on Fri, 16 Jun 2006 15:25:25 -0500,

>I am working in Word 2003. I have exported information from a MAC program
>called FileMaker into Word tables. It works well except that every time the
[quoted text clipped - 7 lines]
>
>Ricki

Reply to this Message

Ricki Miles - 16 Jun 2006 22:34 GMT

Thanks for your reponse. Unfortunately, I do not have the MAC with
FileMaker any more and need to work with the data as it has shown up in
Excel. Also, the boxes are between words, never at the end of a line, so I
don't think that solution would have worked.

Thanks for the advice and I hope I will get other suggestions,

Ricki

> Can you save a copy of your FM file, and replace all the paragraph
> marks or line ending codes with "LINEEND" and then export? Then do a
[quoted text clipped - 16 lines]
> >
> >Ricki

Reply to this Message

<*(((><{ - 17 Jun 2006 01:03 GMT

What if -- you find every character, and color it red; every
punctuation and color it red; every number and color it red; and then
find anything black and replace it with something?

<*((((><{
Fishy@Ocean.Net

In the last exciting episode on Fri, 16 Jun 2006 16:34:50 -0500,

>Thanks for your reponse. Unfortunately, I do not have the MAC with
>FileMaker any more and need to work with the data as it has shown up in
[quoted text clipped - 30 lines]
>> >
>> >Ricki

Reply to this Message

Klaus Linke - 17 Jun 2006 01:53 GMT

Hi Ricky,

You can search for the code...

You need the decimal code, and you can get it with VBA:

Select the character,
open the VBA editor (Alt+F11),
open the immediate window (Ctrl+G),

Type

? AscW(Selection.Text)

When you hit Return at the end of the line, you should get the (decimal)
code.

Say you get

? AscW(Selection.Text)
8364

then use ^u8364 in "Find what:"

Regards,
Klaus

>I am working in Word 2003. I have exported information from a MAC program
> called FileMaker into Word tables. It works well except that every time
[quoted text clipped - 11 lines]
>
> Ricki

Reply to this Message

Ricki Miles - 17 Jun 2006 02:53 GMT

Hi Klaus,

You are my hero - that worked perfectly and it has saved me hours of
replacing the symbol manually. THANK YOU AGAIN!!!

Ricki

> Hi Ricky,
>
[quoted text clipped - 38 lines]
> >
> > Ricki

Reply to this Message

Klaus Linke - 17 Jun 2006 03:51 GMT

Glad it worked!

:-) Klaus

Reply to this Message

<*(((><{ - 19 Jun 2006 09:32 GMT

Bless you Klaus! I've wondered the same thing myself.

<*((((><{
Fishy@Ocean.Net

In the last exciting episode on Sat, 17 Jun 2006 02:53:49 +0200,

>Hi Ricky,
>
[quoted text clipped - 38 lines]
>>
>> Ricki

Reply to this Message