Changing book titles using Trim?
|
#1 : 14/12-23 21:13 Billy
Posts: 1
|
Hello, new to the forum and after having looked at all the posts that seemed to speak to my need, I either 1) am too stupid to understand what I have read or 2) it relates to RegEx and i am trying to use the present methods and so the responses don't apply.
I am trying to remove the first portion of a bunch of file names from example input: Time Odessey 2 Sunstorm, A - Arthur C. Clarke & Stephen Baxter output: Sunstorm, A - Arthur C. Clarke & Stephen Baxter Maybe going a step further I would actually like to remove the comma and put the "A" back in front of Sunstorm for A Sunstorm - Arthur C. Clarke & Stephen Baxter I simply want to erase any thing after the last number in the file name plus the additional space that comes after it. Sometimes the number is multiple digits like 09 or 29. I know it's probably simple but would love to know how to do this. Also if there is a single repository somewhere on the site that has all the expressions that I can use with examples, that would be helpful for me to figure this out in the future myself. I would surmise that some people are going to say "open your eyes...it's right there" But i have been looking for the answers for 2 hours now with no luck. Thanks everyone! |
|
#2 : 15/12-23 16:19 Miguel
Posts: 148
|
Reply to #1: Hi.
I hope this will help you. 1- Replace: [\s\S]*\d "add a space after d" Replace with: Use regular expressions. --------------------------- 2- Replace:, (comma) Replace with: (space) ----------------------------- 3- Move from: [A-Z]+ Move count: 3 Move to: 1 Use regular expressions. ----------------------------- https://i.ibb.co/TTksjX0/Capture1.png https://i.ibb.co/fqJKNs6/Capture-result.png Happy Christmas and happy new year. |
|
#3 : 15/12-23 19:45 Miguel
Posts: 148
|
Reply to #2: Sorry. Think is not working.
Think this will work: 1- Replace: [\s\S]*\d "add a space after d" Replace with: Use regular expressions. --------------------------- 2- Move from: [A-Z ]+ Move count: 4 Move to: 1 Use regular expressions. 3- Remove Remove count=2 Starting: 1 ----------------------------- 4-Replace Text to replace:- replace with: - (space before -) |