Goog Afternoon Statalist users,
I have a database that looks like the following:
Example generated by -dataex-. To install: ssc install dataex
clear
input str100 Politician
"Arthur Alexander (Wilson Center), Hugh Patrick (Wilson Center)"
"Milt Drucker (Director Summit of the Americas, U.S. Department of State)"
"John Sequeira (State Department, Office of Southern Africa Affairs), Ltc Greg Saunders (DOD, Office "
"Mr. Nakamura (president, Kawasaki Steel America)"
"Steven A. Thompson (Professional Staff Member), Roger Smith (House National Security Committee (HNSC"
"S. Chami of Kenya (Ambassador ), Mr. W. Imakando (Embassy of Zambia), Mr. S. Dlamini (Embassy of Swa"
"Randi Sutton,Texas Governor George Bush, Cheryl Parker Rose, Florida
Governor Lawton Chiles (D)."
"Matt Mcmanus (Acting Division Chief, Energy-Producer Country Affairs, U.S. Department of State)"
end
I need to separate the names on each string. My first thought was to separate them by commas, but as you can see there are some commas between parenthesis that would separate things different of names so I need to replace the commas that are between parenthesis to other character and then split the string.
Does anyone nows how to make this replace with the commas only if they are found inside parenthesis?
I've tried this but didn't work:
gen var2 = trim(regexr(Politician,"\((,)+\) *",""))
Thank you very much.
Related Posts with Extracting commas between specific characters
Family Fixed Effects with large number of fixed effectsHi Everyone, I am trying to run family fixed effects. I have a ton of mother ids to identifiy where…
Fitstat gives error messageHi all, When I use fitstat after a ologit regression, I get this message: Code: . fitstat Measur…
Creating Probability VariablesHi, I have a set of variables indicating whether there was a recession in your year of birth or not…
Legend option in Graph barDear All, I want to make a graph bar over a categorical variable (4 categories). My data looks as f…
How to use if statement in foreach loop?I'm attempting to plot gas concentrations over time, but want to format the graphs differently for s…
Subscribe to:
Post Comments (Atom)
0 Response to Extracting commas between specific characters
Post a Comment