Hello,
I have (random) linebreaks that I cannot remove with Notepad++ before importing. Three observations, seven variables, delimiter is |,|:
|id1|,|name1, first1 raw|,|cat1|,|2017|,||,||,|n|
|id2|,|name2, first1 raw|,|cat2|,|2017|,|text1
text2
text3
text4|,||,|n|
|id3|,|name3, first3 raw|,|cat3|,|2017|,||,||,|n|
I am getting too many observations with
import delimited "file.txt", delimiter("|,|", asstring) bindquote(strict) maxquotedrows(unlimited) clear
Is there a way to ignore the linebreak and read lines 2-5 as one line/observation?
Thank you!
Related Posts with Import delimited - ignoring linebreaks
IV Regression Panel Data - xtivreg - lagged VariablesHello, I am working with StataIC16 and the panel data set mathpnl**, for the years 1992 - 1998- I w…
Robust option in a ols modelHi everyone, I was wondering if one can use robust option in a ols regression model that includes bo…
How do I export multiple diagnostic tests to one .csv table?Hello STATAlist friends! I'm working with STATA 15 on a project validating a several tests to gold s…
Store tab command's resultsHi all! I created a variable indicating in which income decile individuals of a population are. I t…
How to extract one variable from a string?We have a dataset of different movies but genres contain more than one variable. For example, under …
Subscribe to:
Post Comments (Atom)
0 Response to Import delimited - ignoring linebreaks
Post a Comment