Grabbing city names and numbers from a CSV file
Leave out the square brackets:

^\d+\s+[A-Z]+\s+


Square brackets are used for "character classes", like

[A-Z]


which matches exactly one letter out of the range A to Z.

\d already is a class: all the numbers.