Close





Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Support Forum Forum Support
How to rename a file after processing (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: How to rename a file after processing
#658
Frank (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
How to rename a file after processing 8 Months, 4 Weeks ago Karma: 0  
I rec reeive a file each day as an e-mail attachment. The attachment is not consitantly named, although it always ends with .txt. I am currently using a mask to select the file for transformation (using *.txt as mask when looking for file).

After I complete the transformation and write the file to the db, I would like to rename the file from *.txt to DATE.done

How do I do this?

Thanks

Frank
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#659
admin (Admin)
Admin
Posts: 147
graph
User Online Now Click here to see the profile of this user
Re:How to rename a file after processing 8 Months, 4 Weeks ago Karma: 0  
Brilliant question

Well it is not strait forward but it is possible

Use file operation action
set operation type to merge file
set source files to whatever the path is + mask
set target file to pathData{GetSystemDate('YYYYMMDD')}.txt

As long as you got only one file matching mask in the directory it should work

Peter
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoard
 

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 
 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.AdvancedETL.aetl9.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner