Hi
I have a scenario where in I need to filter out all the records if I found the specific text any where in the record.
for example I need to filter out all the records where they contain a value IBM.If IBM is part of any where within the record I need to filter out that record.
Can some one please tell me what function has to be used in order to achieve this.
Regards
Kumar
Search for a specific text from a record
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Sep 20, 2011 10:44 pm
- Location: INDIA
The grep command does have some useful options like -v and -i that you may be able to use, especially if you're dealing with a typical text file.
Without using grep, if you need to check all columns, you could create a throw-away column that concatenates all the columns and then use the Index() function in a Transformer constraint.
Another way is to read each entire record from a file into a single char or varchar column, do the Index() check, and then columnize the record.
Without using grep, if you need to check all columns, you could create a throw-away column that concatenates all the columns and then use the Index() function in a Transformer constraint.
Another way is to read each entire record from a file into a single char or varchar column, do the Index() check, and then columnize the record.
Choose a job you love, and you will never have to work a day in your life. - Confucius