July 15, 2010 at 11:25 am
Hello,
I have been reading on Google and here, but I still can't get this to do what I need it to. I have a data table where the users mark old records with the word DELETED in the address field. The problem is, the users may put one or more pairs of asterisk around the word DELETED so it could look like this:
*DELETED*
* * DELETED * *
***DELETED***
I want to remove these records from my data flow. I am trying the FINDSTRING function for the first time, and using that as part of a conditional split. So here is what I have:
FINDSTRING("DELETE",ADDR1,1) > 0
I would like to have two outputs from my conditional split. One for the good records, and one where the word DELETED appears anywhere in the ADDR1 field. When run my package, all of the records flow through to the table of good records. I should actually have about 1/4 of them going to the table for deleted records.
Am I phrasing my statement wrong, or am I misunderstanding what FINDSTRING actually is used for?
thank you
July 15, 2010 at 1:59 pm
You have the parameters in the wrong order, I believe.
July 16, 2010 at 6:26 am
Nevyn (7/15/2010)
You have the parameters in the wrong order, I believe.
D'oh! That was the problem. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply