https://community.qlik.com/t5/Talend-Studio/how-to-trim-dynamic-File-name-for-excel-sheet-name/m-p/2355217#M121017 <P>Assume the Excel filename is in the global variable called "filename", you can do:</P> <PRE>((String)globalMap.get("filename")).substring(0, 13)</PRE> Wed, 30 May 2018 13:28:23 GMT TRF 2018-05-30T13:28:23Z https://community.qlik.com/t5/Talend-Studio/how-to-trim-dynamic-File-name-for-excel-sheet-name/m-p/2355216#M121016 <P>Hi talend folks,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I know <SPAN>how to generate&nbsp;</SPAN>dynamic File name&nbsp;for excel sheet name using talend. Now i want to know&nbsp;how to trim dynamic File name for sheet name. I need specific character only for excel sheet name.&nbsp;</P> <P>&nbsp;</P> <P>example :</P> <P>my excel file name : abcd_20180530_1020</P> <P>need output for excel sheet name:&nbsp;<SPAN>abcd_20180530</SPAN></P> <P>&nbsp;</P> <P><SPAN>Kindly share your information.&nbsp;</SPAN></P> Wed, 30 May 2018 12:39:45 GMT https://community.qlik.com/t5/Talend-Studio/how-to-trim-dynamic-File-name-for-excel-sheet-name/m-p/2355216#M121016 RAJ6 2018-05-30T12:39:45Z https://community.qlik.com/t5/Talend-Studio/how-to-trim-dynamic-File-name-for-excel-sheet-name/m-p/2355217#M121017 <P>Assume the Excel filename is in the global variable called "filename", you can do:</P> <PRE>((String)globalMap.get("filename")).substring(0, 13)</PRE> Wed, 30 May 2018 13:28:23 GMT https://community.qlik.com/t5/Talend-Studio/how-to-trim-dynamic-File-name-for-excel-sheet-name/m-p/2355217#M121017 TRF 2018-05-30T13:28:23Z