Hello,
I have variable that looks like
Experience
('Santo Engineering', '2017-04-30', '2017-05-30', '')('Standard Drum and Bucket Factory', '2019-06-01', '2019-07-01', '')('Team Eclipse Racing', '2020-06-15', '2021-05-08', '')
('nA', '2021-07-01', '2021-07-02', '')
('One Hour Translation', '2021-09-08', '2021-09-14', '')
('Acc Cement', '1996-03-17', '', 30.0)
('Check N Click Learning and Technologies', '2021-07-18', '', 1.0)('No work any organisation ', '2021-07-18', '2021-07-18', '')
Each successive () represents the past experience details of a person, expressions within the parentheses contain: company, start date, end date, months
I would like to extract each string within parenthesis with first parenthesis getting variables named as e1_com, e1_sd, e1_ed, e1_m and if there are more than one parenthesis then the information contained in the second parenthesis should be stored in e2_com, e2_sd, e2_ed, e2_m and so on.....
Will appreciate any help on this. I think regular expressions should resolve this, but unable to figure this one out.
Thanks!
K
Related Posts with Separating string variable with parenthesis and commas
Estimation window for multiple events per companyDear community, I want to perform an event study on dividend announcement effects. My problem is th…
dsregress displays undefined error when Estimating lasso for variables of interestI am currently running a series of lasso regressions and I encountered an error that I cannot identi…
generalised DID with two-way fixed modelDear researchers, I have unbalanced panel data for a set of firms for the year that extends from 200…
Stata Probit Model Interaction Term InterpretationHello everyone, for my thesis i am currently investigating the effects of emissions on health on a …
twoway histogram gen with 0 frequencyHi! I have a question regarding the twoway histogram gen, which is a subroutine for histogram in St…
Subscribe to:
Post Comments (Atom)
0 Response to Separating string variable with parenthesis and commas
Post a Comment