Use Extraction with XXL-Criteria

IDEAListen

Forums

Hi!
I want to create a script that extracts a table with a consistent field structure based on a key.
The user selects the keyvalues from a list that should be excluded during extraction.
This selection is temporarily stored in an array of string.
For l = 0 To UBound(asSelected)
sAcct = iSplit(asSelectedGewaehlte(l),""," - ",1)
If sCrit <> "" Then
sCrit = sCrit & " .AND. ACCT<>" & Chr(34) & sAcct & Chr(34)
Else
sCrit = "ACCT<>" & Chr(34) & sAcct & Chr(34)
End If
Next l
In IDEA, the extraction criteria can unfortunately only be up to 10,000 characters long. Is there a good solution for extraction criteria that are longer than 10,000 characters?

Alternatively, I considered that I would copy the original file and go through the copy line by line to delete the appropriate record sets.

Does anyone have suggestions?

Brian Element Fri, 08/29/2025 - 12:05

Hi IDEAListen,

For a problem like this, instead of using a criteria I would create a new file with the list of selections and then perform a join on the ACCT field, matches only.  It would give you the same result.  Let me know if you need help with the code to create a new IDEA file and place your selection criteria in the new file.

Brian