Hi, Below are some of file names:
and so on
My required output in excel to get Table Names from above file names as below respectively:
Can anyone help on this?
Solved! Go to Solution.
Thanks for Reply
I am getting perfect output but there are some other files which look like:
Required Table Name : fast_read
it replaces all substrings of type <_><any number of digits><_><anything after that> with <""> i.e. empty string.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables