Need help developing a string

I am trying to clean my messy dj library. I am trying to find a way to do multiple functions.

here is an example of what I have and what I trying to get to.
"2 Hard 4 The Fuckin Radio (Aarontheera Edit) (Clean) 100 - 2A - 100"
to
"2 Hard 4 The Fuckin Radio - Aarontheera Edit [LNRP] (Intro Clean)"

I would like to have the title - remix name [DJ Pool Abbrevation] (type i.e. Original, Intro, Quick Hit, Slam In, Acapella In followed by Clean/Dirty). I have been unable to find a way to isolate any section of the title. Can anyone help enlighten me?

Comparing these 2 strings: where would [LNRP] and (Intro come from?

To remove the trailing "100 - 2A - 100"
Try an action of the type "Replace with regular expression"
Search string : (.*) \d+ .*
Replace with: $1

Thank you for your reply. The [LNRP] is shorthand for the dj pool it came from. I.e. BPM Supreme = [BPM], DJ City = DJC, Late Night Record Pool = [LNRP]. I would ideally like create a string that would take the original format with my format including a place holder for the record pool.

Unfortunately, every record pool has their own ways of formatting so I would need to create multiple saved strings for each record pool. I'm just trying to learn how to create the strings so I can modify as needed. I'm just not understanding coding portion since coding is foreign to me.

I tried to point out that unless you have some criteria in the file that can be used to deduct those extra pieces of information, it will be impossible for MP3tag to "guess" this data.

I understand now. My biggest issue is that I don't understand the coding portion of it. If I understood it better, then I could modify my criteria or create multiple actions to reach my end state. For example, I used the information you provided, and it worked for some tracks. For others it deleted too much of the title since the format is different. If only understand that characters meant and how they work in mp3tag I could modify for the other formats.

Means: (.*) take any number of any type of characters and save it a group 1 ... until you reach \d+ .* a space, then at least 1 digit followed by again by any number of characters.
For 2 Hard 4 The Fuckin Radio (Aarontheera Edit) (Clean) 100 - 2A - 100
This applies to 2 Hard 4 The Fuckin Radio (Aarontheera Edit) (Clean)
as then the digit 1 of 100.

See the documentation on regular expressions:

That makes sense but what doesn't make sense is why it doesn't remove numbers in a tile like:
Put The Record On (Extended Mix) 140
or
Summers Back (CC OFH5 Sing It Back Mixshow Edit)(Clean) - 6A - 126
or
Get Up Get Out - Dillon Nathaniel Remix (Dirty) 126 126

There is no space following the digit(s)

6 is not followed by a space but an "A"
and 126 is also not followed by a space as the string ends there.
and so on.