Append Date to File Name

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Pipe-it
Posts: 2
Joined: Thu Dec 29, 2005 12:27 am

Append Date to File Name

Postby Pipe-it » Thu Dec 29, 2005 12:32 am

Hello,

Does anyone know if there is a way to append the date to the end of a filename - like "filename122805.txt" ?

Thanks & Happy New Year!

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Wed Jan 04, 2006 8:17 am

Yes, use a Restrict to Filename filter, and inside it, a Add Right Margin filter with the macro '@date'.

You may need to make the Add Right Margin filter a subfilter of a search/replace filter to get the date added in the correct spot.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Pipe-it
Posts: 2
Joined: Thu Dec 29, 2005 12:27 am

Postby Pipe-it » Mon Jan 23, 2006 6:18 am

Simon Thanks!

This works great on one of our XP machines, but we recently bought another license for our Windows 2003 Server & using the @date macro results in:

"Error,Couldn't move file [D:\Jobs\quantex\all\TXP12C.tmp] to [D:\Jobs\quantex\all\3901949_1/22/2006.xls]:The system cannot find the path specified"

When we disable (un-enable) the "Add right margin @date" part of the filter, the rest of the filiter works fine.

Thanks

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Mon Jan 23, 2006 11:31 am

From the help:
Inserts the date with the system-defined short date format

Ie, go to control panel, and set your Regional settings-short date format to the same as the other machine.

We will change this in the next release to YYYYMMDD - you can use a subsequent search/replace pattern to pickup the date format and re-arrange it. You can use this workaround until we re-release it.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Google [Bot] and 2 guests