I agree that the string that we want to search in should be the first argument to Index, and the string that we are searching for should be the second.
But don't we want to look for
'|':lnk_xfmr_target.CLASS:'|'
in
'|ARC|PPD|CCD|CTX|COR|DNE|'
and doesn't that make the original example correct?
Happy to be corrected
NOT IN in datastage
Moderators: chulett, rschirm, roy
LOL! And the correction is corrected...
It does get confusing because the concept of which one is the "string" and which one is the "substring" reverses when you go into this IN/NOT IN territory. Which made Harish's posted example work out properly in spite of his posted code being wrong - for the task at hand.
Good eye.
It does get confusing because the concept of which one is the "string" and which one is the "substring" reverses when you go into this IN/NOT IN territory. Which made Harish's posted example work out properly in spite of his posted code being wrong - for the task at hand.
Good eye.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers