#1 : 10/10-14 17:26 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! |
#2 : 27/10-14 22:13 Kim Jensen
Administrator
Posts: 883 |
Reply to #1:
Try to add the replace method, check Use regular expressions and use this pattern: InvAmt.*Desc |