GoAnywhere Forum

Hello,

I've got 2 incoming .txt files that need the timestamp removed from the middle of it.

ex. CUSTOMER_66772-01_DEFERRAL_20160929040542.txt
to
CUSTOMER_66772-01_DEFERRAL.txt

I've been looking at the rename command, but I'm not sure about the best way to do this with a File set under the rename command. I'm archiving the file set before this rename, so over writing shouldn't be an issue

Anyone have some insight?

If the position of the timestamp is constant, just do substrings...

${ Concat( Substring(filename, 1, 26), '.txt' ) }

Otherwise, check into the "positionof" and look for the 2nd underscore, then work with the relative positions of the timestamp date.