You are not logged in.
my requirement is this,
i have an address field coming from toracleinput.
i need to check for some cases like :
1)if it contains 'ipv4address'
2)if it contains 'samemsaddress'
For each of the above case I have to perform different transformations which would be to EXTRACT THE IP-ADDRESS FROM the address field itself..
initially, i thought of doing this...write multiple condition in tfilterrow with OR as logic condition...and then perform operation based on which condition is satisfied...BUT HOW DO I EXTRACT SUBSTRING USING TFILTERROW??I am not able to write the condition in tfilterrow : if(row1.address.contains("some_string"))
ex) if the address field is: 'ipv4address:10.113.20.1[tcp:22]' ....then i need to extract 10.113.20.1 from it...
I want to implement this without using tJava ie I want to make this fully automated using the talend components.
tFilterRow component can't extract fields.
You can use tFilterRow to check particular case.
In fact, the best way is to use tExtractRegexFields which can filter and extract address.