Extracting the first few characters of a filename without substring? Data Factory-CodePudding

Home > Enterprise > Extracting the first few characters of a filename without substring? Data Factory

Extracting the first few characters of a filename without substring? Data Factory

Time：09-07

I am working with files that contain their filedate in the filename.

202209021021_example pandas.csv

How do i extract the first 6 characters without using substrings?

Kind regards,

Ayoub

CodePudding user response：

You can use LEFT function in case if you are leveraging dataflows