Remove all characters after last number
Hi everybody.
I have a ton of files that contain:
> A name of varying lengths and a space after.
> A 6 digit letter/number string that always ends in a number and a space after.
> A department name of varying lengths.
Examples:
Steve T00X42 Brakes & Tires.xls
Thomason B95Y75 Transmissions.xls
Ty R62G44 Rear Transaxles.xls
How do I remove everything after the last number? Thank you.
I have a ton of files that contain:
> A name of varying lengths and a space after.
> A 6 digit letter/number string that always ends in a number and a space after.
> A department name of varying lengths.
Examples:
Steve T00X42 Brakes & Tires.xls
Thomason B95Y75 Transmissions.xls
Ty R62G44 Rear Transaxles.xls
How do I remove everything after the last number? Thank you.
Reply to #1:
Hi Ted, welcome back.
If all names are just one word you can use a New name method:
New name: <word:1> <word:2>
If the names can be longer than one word BUT they don't also contain numbers you can use this replace method:
Replace: (.*) ([A-Z0-9]+) .*
With: $1 $2
Occurrence: all or 1st
Case sensitive: YES
Use regular expressions: YES
Apply to: Name
If it's more complex than that we'll need to know more specifics.
Best,
DF
Hi Ted, welcome back.
If all names are just one word you can use a New name method:
New name: <word:1> <word:2>
If the names can be longer than one word BUT they don't also contain numbers you can use this replace method:
Replace: (.*) ([A-Z0-9]+) .*
With: $1 $2
Occurrence: all or 1st
Case sensitive: YES
Use regular expressions: YES
Apply to: Name
If it's more complex than that we'll need to know more specifics.
Best,
DF