topic how to get file name dyanamically in Talend Studio

how to get file name dyanamically

Anonymous — Tue, 23 Oct 2018 17:51:15 GMT

Hi, Below are some of file names:
1)ut_full_load_rta_fast_1_23_20182312_1523.log
2)ut_fullload_first_extract_1_20183101_2356.log
3)ut_catload_dyanamic_overload_fan_2_20182107_1245.log
and so on

My required output in excel to get Table Names from above file names as below respectively:
1)rta_fast
2)first_extract
3)dyanamic_overload_fan

Can anyone help on this?

Re: how to get file name dyanamically

TRF — Tue, 23 Oct 2018 20:56:44 GMT

I suppose you are using a tFileList, so the filename is associated to the variable tFileList_1_CURRENT_FILE. Using a regex you can get what you want for example into an other global variable:
globalMap.put("TableName", ((String) globalMap.get(tFileList_1_CURRENT_FILE).replaceAll("^ut_.*load_", "")).replaceAll ("_[0-9]_.*$", ""))
It's possible there is a syntax error, sorry I can try just now.
Hope this helps.

Re: how to get file name dyanamically

Anonymous — Wed, 24 Oct 2018 06:55:42 GMT

Hi,

Thanks for Reply

I am getting perfect output but there are some other files which look like:

ut_load_fast_read_20181212_1524

Required Table Name : fast_read

Re: how to get file name dyanamically

Anonymous — Wed, 24 Oct 2018 09:50:08 GMT

replaceAll("ut_.*load_", "").replaceAll("_\\d{0,}_.*","");

try this

Re: how to get file name dyanamically

Anonymous — Wed, 24 Oct 2018 10:24:17 GMT

Hi,

Thanks for reply.

This Solution worked.

Can you please explain what does replaceAll("_\\d{0,}_.*","") mean

Thanks,

Raj

Re: how to get file name dyanamically

Anonymous — Wed, 24 Oct 2018 11:25:00 GMT

it replaces all substrings of type <_><any number of digits><_><anything after that> with <""> i.e. empty string.

regards

chandra kant