- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Get the filename date value in Varaible in ODI
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.