Thread: find/replace
View Single Post
  #5  
Old June 4th, 2010, 12:07 PM posted to microsoft.public.word.newusers
Stephen Larivee[_3_]
external usenet poster
 
Posts: 2
Default find/replace

Thank you for your help and the file you worked on. The finished file is
just what I was trying to do. I think my only question would be, How did
you know that the separating mark was ASCII 29?


"Doug Robbins - Word MVP" wrote in message
...

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???