Copy/Rename file using post process mask - VisualCron - Forum

Community forum

Announcement

The VisualCron forum is no longer monitored by VisualCron Support - it is a community forum. Please use our contact page - this ensures tickets are created and prioritized. Thank you!

bsmith
2016-04-09T06:01:15Z
Hello -
I'm trying to rename files to reformat the existing filename for processing.

The current format is:

ab-mmddyyyy-001.txt

The desired format is:

xx-mmddyyyy-0ab.txt

where variable "ab" will always be renamed to "xx" and variable "001" will be replaced with variable "ab".

Basically I am just trying to rename the prefix to always be xx and move the existing prefix to replace the last two characters of the file name. Filenames are always the same length (number of characters).

Is there a way I can use the post process mask to get these variables in the new filename correctly? I can't seem to get the strings right.

Any suggestion is appreciated.
Sponsor
Forum information
thomas
2016-04-11T08:00:46Z
Try this in the post process mask:

xx{STRING(Substring|{NEWNAME()}|2|11)}{STRING(Substring|{NEWNAME()}|0|2)}.txt
bsmith
2016-04-15T00:35:28Z
Thank you. It worked and I am following the logic you used.
Announcement

The VisualCron forum is no longer monitored by VisualCron Support - it is a community forum. Please use our contact page - this ensures tickets are created and prioritized. Thank you!

Scroll to Top