Find and Replace Help

[yippie_ky_yay]

Hello everyone,

I need to replace all spaces with a comma followed by a space (I would rather a comma-dlimeted list rather than just space).

Anyways, I perform the Find/Replace by opening the table, selecting the column, click Edit (from the menu) and then "Replace". I then make sure that my "find" and "replace with" fields are correct - and that "Match:" is set to "any part of the field".

What happens is that it goes to the next record after the first instance has been replaced (which it does correctly by the way). The weird thing is that this only happens sometimes (other times it has replaced all instances of!), which is why I figure that I'm accidently selecting/deselecting something!?!

Any ideas?

Thanks,
-Sean

 

[yippie_ky_yay]

Hi Pat,

there could be - but there are over 400 records, and the pattern is the same (first one, and then none). I also ran a Find/Replace on double spaces to single spaces.

Is there a "after first match go on to the next record" property somewhere is there?

Thanks again,
-Sean

 

[yippie_ky_yay]

Hi again,

I should've been clearer about something on my first post - what happened was that on a copy of my database, I tried to replace all spaces with a comma followed by a space for a particular column. Usually, I would it would change:
itemA itemB itemC
to:
itemA, itemB itemC

so I would remove all the columns and try again, until one time it just worked (I don't remember changing a thing!).

Now that I'm ready to work with the real data, it won't work again. As I said, it will find and replace for the first instance of in the field, but then move on to the record without checking further ...?

-Sean