Is my understanding correct? You have 5900 records, 400 fields with each field having 4 repeated values? What kind of data type do the fields have? Can you share the actual looping script steps you use?

Jens


On Nov 26, 2008, at 7:12 AM, Ron wrote:

I have scripts that cycle thru roughly 5900 records, one column at a time, roughly 400 columns, most repeating up to 4 times.
I expect a number or a short a/n character set, or an empty value.
I am testing the value in each column/repeat for Not IsEmpty.
I am getting invalid data returned, so the Not IsEmpty doesn’t work.
How else can I test the value to reject whatever this invalid data is?
Or, from another point of view, how would these values be initialized so I could test for that?

Many thanks!

Ron Carr

Jens Selvig
...Lost in Montana...

Reply via email to