Databases
StackOverflow2013
Postsdbo
POError in reading a massive file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError in reading a massive file
    primarykey
    data
    text
    <p>I have very large text message which contain <strong>""</strong>,*<em>\n</em>* but while reading a file whose one of the column contain text is not getting read properly just because message contain <strong>""</strong> and <strong>"\n"</strong>. I have used the following</p> <pre><code> dat = read.csv("abc", header=F, sep=",", quote ="\"'", stringsAsFactors=FALSE, allowEscapes=T, flush=T, comment.char="") </code></pre> <p>It reads file incorrectly with read.csv and reading as a table,getting an error</p> <pre><code> dat = read.table("abc", header =F,sep="," , quote = "\"'",,stringsAsFactors = FALSE,allowEscapes=T,flush =T,comment.char="") Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : line 38 did not have 20 elements </code></pre> <p>So my row gets break in message column,I saved my file as <strong>eol</strong> ='\r\r\n' and <strong>quote=T</strong> but while reading I didn't find any parameter to read it back in the same format. saved file as </p> <pre><code> write.table(z,file="abc",append=F,quote=T,sep=",",eol="\r\r\r\r\r\n",row.names=F,col.names=F) </code></pre> <p>in this example </p> <pre><code> "In case you know,give some hint lot of text..... ................. --------------------------------------------------------------------------- \"thank you very much for your time and your effort\" ---------------------------------------------------------------------------" </code></pre> <p>it breaks after</p> <pre><code>"In case you know,give some hint lot of text..... ................. --------------------------------------------------------------------------- \"thank you very much for your time </code></pre> <p>while reading how can i <strong>use eol in order to retrieve complete text message in the same column</strong> .I am not able to read a written file back,though the file successfully uploded in Mysql with loading script.Any help in this direction. thanks.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAashu
    1. USAashu
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POError in reading a massive file
      1. This table or related slice is empty.
      1. VTModeratorReview
    2. VO
      singulars
      1. POError in reading a massive file
      1. This table or related slice is empty.
      1. VTModeratorReview
    3. VO
      singulars
      1. POError in reading a massive file
      1. This table or related slice is empty.
      1. VTUndeletion
    1. COWhat is the question?
      singulars
      1. POError in reading a massive file
      1. USsckott
    2. COYou'll get more help if you state exactly what error message you're getting, and show a sample of your data in a way others can easily use (ie put the csv file on a file sharing website). In any case, you probably just need to experiment with `quote = ""` and similar arguments to `read.csv` to get over this hurdle.
      singulars
      1. POError in reading a massive file
      1. USBen
    3. COI edited the question and wrote error as well ,hope it is now clear.
      singulars
      1. POError in reading a massive file
      1. USAashu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload