Removing a non-static section of a file name

Advanced Renamer forum
#1 : 10/10-14 17:26
Jeff
Jeff
Posts: 2
Hi, I need help removing a section of a file name where the values from "InvAmt:" up to "Desc:" need to be removed from the file name. The values between "InvAmt" & "Desc:" vary between files.

Example:

Original File Name:
2012-11-24 Vnd#: EQUUS Acc #: 2106230 Inv#: 1259069-RM InvDte: 2012-10-31 InvAmt: -107.00 Payee: ASI-BBT0535 Ck#: 007609 CkDate: 2012-11-24 Ck Amt: 11.52 Desc: NOBLEVIEW SN:Z9NW817V1148 - RMA Link: NA

Need to Remove:
"InvAmt: -107.00 Payee: ASI-BBT0535 Ck#: 007609 CkDate: 2012-11-24 Ck Amt: 11.52"

Resulting File Name:
2012-11-24 Vnd#: EQUUS Acc #: 2106230 Inv#: 1259069-RM InvDte: 2012-10-31 Desc: NOBLEVIEW SN:Z9NW817V1148 - RMA Link: NA

Any suggestions would be greatly appreciated!


10/10-14 17:26
#2 : 27/10-14 22:13
Kim Jensen
Kim Jensen
Administrator
Posts: 771
Reply to #1:
Try to add the replace method, check Use regular expressions and use this pattern:
InvAmt.*Desc


27/10-14 22:13