Support Questions
Find answers, ask questions, and share your expertise

NIFI get new attribute from the filename CSV

Explorer

hello! 
I have a CSV files, a lot of CSV files from sftp.

I need to get the store name from the filename and append that to one of the columns.

The filenames are very different, number of characters before and after changes
for ex.,
ftp_123245_ECCO_160921.csv
ftp_1984_remont_msk_and_spb_200721.csv
taxcom_2345_ashan_17122021_2.csv
also I need to get the date from the filename and append that to one of the columns as you can see there are also in different formats, I need update it to 'yyyy-mm-dd'

THANKS

 

 

0 REPLIES 0
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.