- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.2K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Filter with Strfind(field1,'T')<>1 not working when the field itself is a primary key
my requirement is to stop data from extracting when the field data starts with 'T'.
so, in extract, I've used filter and strfind(field,'T')<>1 , which works fine for fresh records in source DB.
But if this field is primary key and then if the value of this field gets changed from
1000 to T001 --> then it should nt get extracted , but this is not working with the above strfind and filter.
Any thoughts/suggestions ?