I have a text variable that I want to strip of a section of each line.
below is a sample of the text I have for the variable
Richfield (pop. 34,439)
Robbinsdale (pop. 14,123)
Rochester (pop. 85,806)
Rosemount (pop. 14,619)
Roseville (pop. 33,690)
Sartell (pop. 9,641)
Sauk Rapids (pop. 10,213)
what I am wanting to strip out is the end area the (pop. ... )
if this makes sense I would be greatly appreciative of any help on this area.
thanks