How to move = to front?
#1 : 23/09-20 18:05 SAM
Posts: 9
|
Hi.
File name: INV_20200924_IVA01_$100_CUSTOMER Z INV_20200924_IVA01_$100_CUSTOMER Z=IVB01 INV_20200924_IVA02_$102_CUSTOMER Y INV_20200924_IVA02_$102_CUSTOMER Y=IVB02 How to rename as follow? INV_20200924_IVA01_$100_CUSTOMER Z INV_20200924_IVA01=IVB01_$100_CUSTOMER Z INV_20200924_IVA02_$102_CUSTOMER Y INV_20200924_IVA02=IVB02_$102_CUSTOMER Y Thank you. |
#2 : 23/09-20 23:21 David Lee
Posts: 1125
|
This should do the trick...
Replace: (.*)(_\$.*)(=.*) With: \1\3\2 Use regular expressions |
|
#3 : 23/09-20 23:46 SAM
Posts: 9
|
Reply to #2:
Thank you Mr. David Lee. It works! |
|
#4 : 23/09-20 23:53 SAM
Posts: 9
|
Reply to #2:
How about this? File name: INV_20200924_IVA01_USD100.50_CUSTOMER Z INV_20200924_IVA01_USD100.50_CUSTOMER Z=IVB01 INV_20200924_IVA02_USD102.99_CUSTOMER Y INV_20200924_IVA02_USD102.99_CUSTOMER Y=IVB02 How to rename as follow? INV_20200924_IVA01_USD100_CUSTOMER Z INV_20200924_IVA01=IVB01_USD100_CUSTOMER Z INV_20200924_IVA02_USD102_CUSTOMER Y INV_20200924_IVA02=IVB02_USD102_CUSTOMER Y |
|
#5 : 24/09-20 09:32 David Lee
Posts: 1125
|
Reply to #4:
Replace: (.*)(_USD\d+)(\.\d*)?(_[^=]*)(=.*)? With: \1\5\2\4 Use regular expressions |