Remove English characters from the middle of two sets of numbers？

jeffli · 2019-01-22 03:01

Hi and thank you for this incredible program, very useful.

My issue is this : Remove English characters from the middle of two sets of numbers
For example:"2019-1-22 ground tube 001.docx”
my goal："2019-1-22 001.docx”

Is there an easier way to do it?
Thanks in advance

Stefan · 2019-01-22 15:16

Hi and welcome!

Sounds like Strip rule
http://www.den4b.com/wiki/ReNamer:Rules:Strip

could be what you're looking for?

jeffli · 2019-01-22 15:33

Stefan wrote:

Hi and welcome!
Sounds like Strip rule
http://www.den4b.com/wiki/ReNamer:Rules:Strip
could be what you're looking for?

Hi Stefan,
Thank you.
Maybe my example is inappropriate, i want to do this:
origin file name:

0.0014 inch precision ground tube 0.0014 inch ground tube.docx
0.0018 inch raw tube 0.0018 inch tube.docx
HX outer package box HX package box.docx
...etc.

rename to:

0.0014 inch precision ground tube.docx
0.0018 inch raw tube.docx
HX outer package box.docx
...etc.

It is a little difficult to use Strip rule.

Last edited by jeffli (2019-01-22 15:42)

Stefan · 2019-01-22 15:37

We need to find an common "anchor point".
So. always remove from the second found number till the end?

jeffli · 2019-01-22 15:44

Stefan wrote:

We need to find an common "anchor point".
So. always remove from the second found number till the end?

for example:

"0.0018 inch raw tube 0.0018 inch tube.docx" rename to "0.0018 inch raw tube.docx"
"HX outer package box HX package box.docx" rename to "HX outer package box.docx"

I always remove words from second "0.0018" or "HX".

Stefan · 2019-01-22 16:43

Try that:

FROM:
0.0014 inch precision ground tube 0.0014 inch ground tube.docx
0.0018 inch raw tube 0.0018 inch tube.docx
HX outer package box HX package box.docx

TO:
0.0014 inch precision ground tube.docx
0.0018 inch raw tube.docx
HX outer package box.docx

USE:
Regular Expressions (http://www.den4b.com/wiki/ReNamer:Rules:RegEx)

Expression "^(.+)#(0\.|HX).+$"
Replace with "$1"
(skip extension), maybe check (case-sensitive) too

NOTE: instead of hash-sign #, enter a blank space.

Explanation:
^ >>>>>> Start at the beginning
(.+) >>> Match one-ore-more of any sign and capture for re-use, untill...
#(0\.|HX).+$ >>>> Space, followed by 0. or HX and the rest till the end
$1 >>>> Replace whit what was captured by first (...) capture group

See http://www.den4b.com/wiki/ReNamer:Regular_Expressions for more....

works?

jeffli · 2019-01-22 16:55

Stefan wrote:

Try that:

FROM:
0.0014 inch precision ground tube 0.0014 inch ground tube.docx
0.0018 inch raw tube 0.0018 inch tube.docx
HX outer package box HX package box.docx
TO:
0.0014 inch precision ground tube.docx
0.0018 inch raw tube.docx
HX outer package box.docx
USE:
Regular Expressions (http://www.den4b.com/wiki/ReNamer:Rules:RegEx)
Expression "^(.+)#(0\.|HX).+$"
Replace with "$1"
(skip extension), maybe check (case-sensitive) too

NOTE: instead of hash-sign #, enter a blank space.

Explanation:
^ >>>>>> Start at the beginning
(.+) >>> Match one-ore-more of any sign and capture for re-use, untill...
#(0\.|HX).+$ >>>> Space, followed by 0. or HX and the rest till the end
$1 >>>> Replace whit what was captured by first (...) capture group
See http://www.den4b.com/wiki/ReNamer:Regular_Expressions for more....

works?

Hi Stefan,
It works, thank you for your help, very good Regular Expressio.

den4b Forum

#1 2019-01-22 03:01

Remove English characters from the middle of two sets of numbers？

#2 2019-01-22 15:16

Re: Remove English characters from the middle of two sets of numbers？

#3 2019-01-22 15:33

Re: Remove English characters from the middle of two sets of numbers？

#4 2019-01-22 15:37

Re: Remove English characters from the middle of two sets of numbers？

#5 2019-01-22 15:44

Re: Remove English characters from the middle of two sets of numbers？

#6 2019-01-22 16:43

Re: Remove English characters from the middle of two sets of numbers？

#7 2019-01-22 16:55

Re: Remove English characters from the middle of two sets of numbers？

Board footer