Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Extract basename

Hello,
I search how I can extract the basename without the extend of a file:
toto.txt --> toto
Thank you for help me
Quartz
Paris (with snow !!) - France
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
Using tFileProperties to get the basic information of a file, including the size, basename etc. and then parse the basename on tJavaRow, for example:
(tFileList--iterate-->)tFileProperties--main--tJavaRow
on tJavaRow:
String basename=input_row.basename.substring(0,input_row.basename.indexOf("."))

Best regards
Sabrina