Extra the file name

Question

I have a file named Team_worksales_2023-12-20.xlsx

I want to extract date value 2023-12-20 with the derived column.

I tried to use findstring but it gives the value 2023-12-20.xlsx

How to remove the.xlsx？

Answer 1

Hi @L Tune,

You may try with below expression.

Left(TOKEN(@[User::FileName], "_", 3),10)

or

left(right(@[User::FileName],15),10)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi L Tune

you can use a combo of string functions in your expression. Assuming you are working with SSIS and using a derived column transformation,

(DT_STR, 10, 1252) SUBSTRING(FINDSTRING([YourFileNameColumn], "_", 1) + 1, 10)

Replace file name with the actual column name that contains the file name. This assumes that the date portion is always in the format "YYYY-MM-DD" and is preceded by an underscore in the filename.

IIf this helps kindly acce[pt the answer thanks much.