Clear function

[Jessica]

I'm wondering why the clear function only clears the fields displayed in the current layout.

I want to clear all fields but only the fields displayed in layout 1 is cleared and not in layout 2, although in my script, I wrote

clear [field1]....clear [fieldn] for all my fields.

Any thoughts? Is this normal? Should I use cut, or select field, ""?

[LiveOak]

Clear is like Cut and Paste. The field it operates upon must be present on the current layout for the script step to work. A much better to way is to use the Set Field (Field, "") script step. This step does not require a field to be visible on the current layout to work.

-bd

[Jessica]

Thanks, I did just that.

[eremaut]

Hi,

From LifeOak: "A much better way is to use the Set Field (Field, "") script step."

Yes, and not only that, it's also faster. In a loop with 5000 records this gives a very important boost! So, better never use the Clear-script again.

Erwin

[LiveOak]

There is a bit of a trade-off. For a few fields, multiple replace functions can be faster for a large number of records. For a lot of fields, the looping approach is faster. You just have to do some testing. I have scripts which perform some replaces and some looping.

-bd