Hi,

I have a dataset of about 1000 articles with variables such as id, title, abstract and affiliation. I was unable to get a dataex due to an error:
Code:
input strL affiliation
data width (7267 chars) exceeds max linesize. Try specifying fewer variables
r(1000);
I have to separate the affiliation details (e.g. school, department, email), street address and country names into different columns, but my main interest is in the country names for each row. Is it possible to do so using Stata 16? Here are first 2 rows.

Department of Radiation Oncology, University of Brescia and Spedali Civili and Hospital, Brescia, Italy. and Department of Radiation Oncology, University of Brescia and Spedali Civili and Hospital, Brescia, Italy. and University Department of Infectious and Tropical Diseases, University of Brescia and and ASST Spedali Civili, Brescia, Italy. and Department of Molecular and Translational Medicine and Clinical Chemistry and Laboratory ASST Spedali Civili, Brescia, Italy. and Department of Radiation Oncology, University of Brescia and Spedali Civili and Hospital, Brescia, Italy. and Department of Radiation Oncology, University of Brescia and Spedali Civili and Hospital, Brescia, Italy; a.e.guerini@gmail.com. and Department of Radiation Oncology, University of Brescia and Spedali Civili and Hospital, Brescia, Italy.
Division of Allergy, Pulmonary, and Critical Care Medicine, Vanderbilt University and Medical Center, Nashville, TN, USA. Electronic address: and Jonathan.D.Casey@VUMC.org. and Vanderbilt Center for Biomedical Ethics and Society, Vanderbilt University and Medical Center, Nashville, TN, USA. and Office of Emergency Care Research, National Institute of Neurological Disorders and and Stroke, Division of Clinical Research, National Institutes of Health, and Bethesda, MD, USA.