Page 1 of 1
Substring in Filter
Posted: Wed Feb 24, 2010 2:43 pm
by kittu.raja
Hi Everyone,
Can we use substring function in a filter.
Like in transformer column_name[1,6] = 7777
Can we do the same in a filter? If yes what is the syntax
Thanks in advance.
Posted: Wed Feb 24, 2010 2:48 pm
by DSguru2B
I do not think that is possible in a filter stage. The filter stage only filters records, unmodified.
Posted: Wed Feb 24, 2010 4:00 pm
by ray.wurlod
One task, one stage.
The Filter stage filters.
If you need substring perform that in an upstream Modify or Transformer stage.
Posted: Mon Mar 26, 2012 8:45 am
by devo
Is it possible to then do something like a SQL "LIKE" command?
Posted: Mon Mar 26, 2012 9:25 am
by mobashshar
Yes.. you can use LIKE condition in Filter
Posted: Mon Mar 26, 2012 9:40 am
by jwiles
The filter option is calling an external command/script/program on the operating system. Therefore, you have whatever functionality is provided within that command/script/program.
Regards,
Posted: Mon Mar 26, 2012 3:10 pm
by ray.wurlod
I think they're talking about the Filter
stage, James.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Mon Mar 26, 2012 10:00 pm
by jwiles
Well I'll be darned...how'd I miss THAT?
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Posted: Tue Mar 27, 2012 4:42 pm
by qt_ky
I'm not seeing where it says stage vs. seq. file option. vs. coffee, etc.