Find/Replace...

[Paolo]

i've a script that performs a find/replace... using the values stored in two globals: gFind and gReplace.

the find/repl is performed on every record in the current found set on only one field.

It works ok, but sometimes 1 record is left out from the find/replace... operation.

In other words it does the find/replace on all records in the found set except one.:

when this happens, that record is selected and the cursor is in the field.

Any idea?

Thanks!

[BobWeaver]

Is this a multiuser solution? If so, it could be that someone else is editing the record when you run the script. In that case the record would be locked and the replace would skip it.

[Paolo]

no, single user. local

[Lee Smith]

How about pasting your script?

[Paolo]

what do you mean?

[Lee Smith]

[color:"green"] >> i've a script that performs a find/replace...

[color:"blue"]> what do you mean?

Your Script Steps.

[John Caballero]

Hi Paolo. I think Lee is asking for you to show us the script in question by pasting (can you actually paste the script steps, Lee?) for all to see. Look around at some other threads for an example - it's often helpful if we can see what your script steps are.

[Paolo]

Ah!

GoToField [select/Perform, "description" ]

Perform Find/Replace[No dialog, "gFind","gReplace","Replace All"]

The complete settings for Perform Find/Replace are:

Perform: Replace All

Find What: Field Value -> gFind

Replace With: Field Value ->gReplace

Direction: All

Match case: NO

Match whole words only: NO

Search across: All records/requests

Search within: Current field

[Paolo]

Btw:

>How about pasting your script?

I would really love to be able to copy/paste script steps!!!

[Lee Smith]

There are utilities that will let you Print to Text, which in turn you can then copy and paste in your post.

Take a look what is available here:

http://www.fmfiles.com/dev12.html

The Print2Pict is excellent for this and a very useful development tool. If you are on a Windows machine, there is an equivalent, but I don't remember it's name.

Lee