After importing from Excel (-import excel-; .xlsx), I have some string variable values that comprise multiple lines.
For example:
Code:
. di var1[108]
This
is
one
string variable
.
Thanks in advance,
Reese
v 14.2
Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.
Monday, March 4, 2019
help with string variable comprising multiple lines
Hi Statalist,
After importing from Excel (-import excel-; .xlsx), I have some string variable values that comprise multiple lines.
For example:
Is there any way to trim this to one line? Or is that something that needs to be done in Excel before I import?
Thanks in advance,
Reese
v 14.2
After importing from Excel (-import excel-; .xlsx), I have some string variable values that comprise multiple lines.
For example:
Thanks in advance,
Reese
v 14.2
No comments:
Post a Comment