Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

finding blanks and non blanks


the walker

This topic is 7859 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi

am trying to clear five fields over around a thousand records for a script.

this take a while to loop through the lot so i need to cut it down to record just with text in the five fields

does any one know how i can script it to enter in "" into a field to find any text

if not does any one know how to find blank fields in a script the i can just show omitted and hey presto i have my record set i need

cheers all

Link to comment
Share on other sites

To find non empty values in TEXT field use following

Set error Capture [on]

Freeze Window

Enter Find Mode[]

SetField [field1, "="]

New Record Request

SetField [field2, "="]

...

...

Perform Find

If [status(CurrentFoundCount)]

Show omtted

Perform Script [Your Script For Clearing Fields]

else

//Handle no records found

end if

Dj

Link to comment
Share on other sites

This topic is 7859 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.