Forum Stats

  • 3,825,886 Users
  • 2,260,571 Discussions
  • 7,896,720 Comments

Discussions

Get the filename date value in Varaible in ODI

user12251389
user12251389 Member Posts: 334 Blue Ribbon
edited May 3, 2022 10:05AM in Data Integrator

Hallo All,

I receive daily file which has previous date suffixed for example i receive filename like 'export_20220502'. Now i want to store this previous filename date value into variable.

I can then use this variable value in expression in mapping for inserting into one of the database table field. But currently i have no idea or dont know the best easiest way to get the filename date into variable.

Can anyone give some idea ? I was thinking to write shell script in odoscommand to get the date from filename. But then i dont know how to pass this in variable.

Thanks!

VG.

Tagged:

Answers