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?
Removing Datestamp from a Decrypted file set
Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: Removing Datestamp from a Decrypted file set
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.
${ 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.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696