topic Re: Filtering integer value from input stream in tJava in Talend Studio

Filtering integer value from input stream in tJava

Anonymous — Sat, 16 Nov 2024 04:12:39 GMT

The result of CurrentKey value of tS3_List is as follows:
FolderName1/FolderName2/1970/01/01/file_name.csv.gz

I need path like:
FolderName1/FolderName2/1970/01/01/

How do I filter the integer value from "(String)globalMap.get("tS3List_1_CURRENT_KEY")" to get the path I mentioned above?

Re: Filtering integer value from input stream in tJava

Martintin — Thu, 31 Oct 2019 07:34:50 GMT

Hi,

If i understand well, all you want to do is cutting the last part of the String (file_name.csv.gz) ?

If yes, you can do like that :

I think it's not the better way to achieve it but it's working.

Warm Regards

Re: Filtering integer value from input stream in tJava

TRF — Thu, 31 Oct 2019 08:07:13 GMT

This one better as it doesn't depend of the number of parts: ((String)globalMap.get("tS3List_1_CURRENT_KEY")).substring(((String)globalMap.get("tS3List_1_CURRENT_KEY")).lastIndexOf('/')

Can't check the result from my phone but should work

Re: Filtering integer value from input stream in tJava

Anonymous — Fri, 01 Nov 2019 08:27:21 GMT

Thanks for the quick reply!

It worked.

Regards,

Bhagwat