I"m not familiar with using the team A function....
Hah, me neither. My "Team A" was a failed attempt to demonstrate a team name of some sort to be added in front of a player name. Sorry about causing confusion.
If your starting point is records having TAB-separated fields as shown, there will be several ways to insert a team name just about anywhere.
You have already used the regular expression special character circumflex (^) to indicate "start of line" (or rather start of text). A regular expression (regexp) recognizes quite a few special characters, like the dollar sign ($) meaning the "end of line" (or rather end of text) in case you run into that.
The first thing you probably need to know about at this point is the \t (backslash t) which means TAB.
There are a few more things to know, as well:
\d is a digit 0-9
\d+ is one or more digits
\w is word character, meaning any letter A-Z or a-z or any digit 0-9. A character we use when constructing a word, basically
\w+ means one or more word characters, \w+ essentially means one non-empty word.
Thus, in regexp speak the relevant beginning of your input lines are recognized as: ^\d+\t\w+
It spells: at start of line, one or more digits, then a TAB and then at least one word caracter. It fits 34TABNigel on your first input line. If you want it to fit Nigel Bracey you need ^\d+\t\w+\s+\w+ That adds at least one space and one more word to the mix.
Don't worry, you can probably get away with just ^\d+\t (start of line, then at least one digit and then TAB) to put a team name in front of the name, but I think you should learn just one more concept. Grouping by parenthesis. If you rewrite ^\d+\t to ^(\d+)\t you make the digits into a group for later reference. No worries, you already know how to use alternative code replacements in PM (#1, #2 etc, and your regexp group of digits is similar).
Find what: ^(\d+)\t
Replace with c\1\tTEAM-NAME-HERE\t
The \1 references the first group in the Find what statement, the digit collection that is. You put them after the leading c character. If you expanded the find to ^(\d+)\t(\w+), you could reference the second group found (a player's first name like Nigel, that is) using \2. If you followed this far, you should now be able to put the team name between the player's first and last name...
Note that I added a \t to insert a TAB after the team name (I tried something more obvious than "Team A" here
. I suggest keeping entities in separate fields (or separate columns if you like) rather than combining several entities, like team name and person name, in one field. If you would rather want to have the team name in the name field (column) separated from the name string by a space, then put a space rather than a \t at the end of the team name.
I feel this discussion forum may be the wrong place to teach regular expressions, I may unintentionally have annoyed a lot of PM users already. Jeffrey Friedl once wrote the excellent book "Mastering Regular Expressions" published by O'Reilly. I think it can be downloaded as a PDF by now, possibly at almost no cost. Check it out.
PS. I managed to misspell Jeffrey Friedl's name, now fixed.