Forum Stats

  • 3,769,310 Users
  • 2,252,947 Discussions
  • 7,874,983 Comments

Discussions

Filter with Strfind(field1,'T')<>1 not working when the field itself is a primary key

User_IMO5J
User_IMO5J Member Posts: 2 Green Ribbon

Hi GUys,

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 ?

Answers