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
Calculating proportions of the make-up of different program groups at different measurement occasions - helpHello, My dataset consists of ~6000 referrals to a suite of four types of psychological programs ov…
Mixed Design ANCOVAHi guys, I am having difficulties with choosing an appropriate statistical analysis for my research…
Integer related issueI'm new to STATA. I used Excel prior but recently purchased STATA. I'm learning as I go. Here is my …
Graphing two categorical variablesHello everyone, I'm new to the Forum and relatively beginner at Stata, so sorry if the answer for w…
Choice model (cm) data layoutHi all, I am in the midst of setting up my data to run a panel-data mixed logit choice model (cmxtm…
Subscribe to:
Post Comments (Atom)
0 Response to Import delimited - ignoring linebreaks
Post a Comment