[resolved] tMap Expression filter - compare substrings with variable length

mertez — Wed, 15 May 2013 16:46:12 GMT

I am looking to compare a fixed string with a variable string that can be of different sizes. Let's say that I want to filter rows that matches the following criteria:
Expression filter:
"abcd".compareTo(a.substring(0, 4)) // where a is a string with variable length

The problem arrises when a="ab" or whenewer its length is lower than 4 characters. In this case "index out of bound exception" is thrown.

I can solve this with first chechking the variable string lenght but I am looking for a cleaner solution.

Re: [resolved] tMap Expression filter - compare substrings with variable length

mertez — Wed, 15 May 2013 17:24:27 GMT

I have found a better solution in a library StringHandling from Talend. Above problem can be solved with INDEX method which rerutns a starting position of the compared string.
ex:
StringHandling.INDEX(a,"abcd")
same but in Java:
a.indexOf("abcd")

topic Re: [resolved] tMap Expression filter - compare substrings with variable length in Talend Studio

[resolved] tMap Expression filter - compare substrings with variable length

Re: [resolved] tMap Expression filter - compare substrings with variable length