Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


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.
Scroll to Top