How to Renumber?
Hello.
File name:
INV_20200924_IVA01_$100.00_CUSTOMER Z
INV_20200924_IVA01=IVB01_$100.00_CUSTOMER Z
INV_20200925_IVA02_$102.00_CUSTOMER Y
INV_20200925_IVA02=IVB02_$102.00_CUSTOMER Y
NV_20200926_IVA02_$104.00_CUSTOMER X
INV_20200926_IVA02=IVB03_$104.00_CUSTOMER X
NV_20200927_IVA02_$106.00_CUSTOMER W
INV_20200927_IVA02=IVB04_$106.00_CUSTOMER W
How to rename as follow?
INV_20200924_01_IVA01_$100.00_CUSTOMER Z
INV_20200924_01_IVA01=IVB01_$100.00_CUSTOMER Z
INV_20200925_02_IVA02_$102.00_CUSTOMER Y
INV_20200925_02_IVA02=IVB02_$102.00_CUSTOMER Y
INV_20200926_03_IVA02_$104.00_CUSTOMER X
INV_20200926_03_IVA02=IVB03_$104.00_CUSTOMER X
NV_20200927_04_IVA02_$106.00_CUSTOMER W
INV_20200927_04_IVA02=IVB04_$106.00_CUSTOMER W
Thanks.
File name:
INV_20200924_IVA01_$100.00_CUSTOMER Z
INV_20200924_IVA01=IVB01_$100.00_CUSTOMER Z
INV_20200925_IVA02_$102.00_CUSTOMER Y
INV_20200925_IVA02=IVB02_$102.00_CUSTOMER Y
NV_20200926_IVA02_$104.00_CUSTOMER X
INV_20200926_IVA02=IVB03_$104.00_CUSTOMER X
NV_20200927_IVA02_$106.00_CUSTOMER W
INV_20200927_IVA02=IVB04_$106.00_CUSTOMER W
How to rename as follow?
INV_20200924_01_IVA01_$100.00_CUSTOMER Z
INV_20200924_01_IVA01=IVB01_$100.00_CUSTOMER Z
INV_20200925_02_IVA02_$102.00_CUSTOMER Y
INV_20200925_02_IVA02=IVB02_$102.00_CUSTOMER Y
INV_20200926_03_IVA02_$104.00_CUSTOMER X
INV_20200926_03_IVA02=IVB03_$104.00_CUSTOMER X
NV_20200927_04_IVA02_$106.00_CUSTOMER W
INV_20200927_04_IVA02=IVB04_$106.00_CUSTOMER W
Thanks.
You need to use a script for this one.
First, enter this code in the Pre batch script:
var suffix = 1;
var lastID = app.getItem(1).name.match(/_\d*_/)[0];
Then, in the main script window:
match = item.name.match(/(.*)(_\d*_)(.*)/);
ID = match[2];
if (ID != lastID) {
lastID = ID;
suffix += 1;
}
return match[1] + ID + ("00" + suffix).slice(-2) + "_" + match[3];
Read the User Guide sections on Scripting and Regular Expressions.
For more advanced information search the Internet.
I find resources at www.w3schools.com and www.regular-expressions.info particularly helpful
First, enter this code in the Pre batch script:
var suffix = 1;
var lastID = app.getItem(1).name.match(/_\d*_/)[0];
Then, in the main script window:
match = item.name.match(/(.*)(_\d*_)(.*)/);
ID = match[2];
if (ID != lastID) {
lastID = ID;
suffix += 1;
}
return match[1] + ID + ("00" + suffix).slice(-2) + "_" + match[3];
Read the User Guide sections on Scripting and Regular Expressions.
For more advanced information search the Internet.
I find resources at www.w3schools.com and www.regular-expressions.info particularly helpful