title: Having troubles reading a txt file into R with columns delimited by ||
body: <p>I'm having troubles trying to read a .txt file consisting of 561366 rows and 15 columns. The first rows look something like this:</p>
  
  <pre><code>  70000||Consumer A||23||DN||70000||10038782||1||SI||2||NO||0||N/A||0||N/A||1
    90000||Consumer B||23||DN||90000||15402432||1||SI||2||NO||0||N/A||0||N/A||1 
    .
    .
    .
  </code></pre>
  
  <p>The code I'm using for reading the file is:</p>
  
  <pre><code>  Datos &lt;- read.table("C:/Users/hernandezn/Desktop/DataSets/INACTIVOS.txt", 
    header=FALSE, sep="|", na.strings="N/A", dec=".", strip.white=TRUE)
  </code></pre>
  
  <p>As you can see, my columns are separated by <code>"||"</code>, but I can't use it in the R command <code>read.table</code> as a<code>sep</code> option. So, I've used <code>sep="|"</code> and have to pay the price for that (now I have 29 columns). </p>
  
  <p>The problem is that I'm just getting 241116 rows out of the  561366 I have in my file. On the other hand, I tried reading this file by replacing the <code>"||"</code> symbols by <code>;</code> and saving it as a .xlsx file and I'm getting all rows this way.</p>
  
  <p>Could you suggest me a way to solve this problem? could it be a memory issue? I have a 32 bits R version running on a computer with 2GB of Memory Ram.</p>