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!
0 Response to Import delimited - ignoring linebreaks
Post a Comment