Thread: find/replace
View Single Post
  #4  
Old June 4th, 2010, 12:09 AM posted to microsoft.public.word.newusers
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default find/replace

The unknown character is a Group Separator (ASCII 29) and to deal with it
you must use

ActiveDocument.Range.Text = Replace(ActiveDocument.Range.Text, Chr(29),
Chr(9))

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Stephen Larivee" wrote in message
...
Win XP, Word 2003

I exported a field in FileMaker Pro. It is a repeating field with two
dates in one field. I thought I could import the field into Word and find
the marker that separates one date from the next and do a Replace All and
put a Tab between the two dates and then put the dates into two different
fields, the way they belong. I have the field in Word and there is a
small rectangle between the dates. So far nothing I have used as a Find
has "found" it, except for White Space (^w), but when I do a find ^w and
replace ^t, Word replaces thousands of the occurences but the demon white
rectanges remain. I even tried copying and pasting the rectange into the
Find box but that is not working.

I have a posting on a FileMaker Pro board to see if someone can show me
how to separate the dates from with FileMaker, but it seems I should be
able to do it from within Word.

Does anyone have a suggestion???