On Tue, Oct 1, 2013 at 3:51 PM, Hoover, Jeffrey <[email protected]> wrote:
> I am trying to import a tab delimited file into a table containing 21 > columns. > > It fails on this record > Sapurv10037426m 176 RPS-BLAST(BLASTP) cdd > gnl|CDD|239293 72 159 1 89 33.7 56.5 174 > 70.7 92 cd02995, PDI_a_PDI_a'_C, PDIa family, C-terminal TRX domain > (a') subfamily; composed of the C-terminal redox active a' domains of PDI, > ERp72, ERp57 (or ERp60) and EFP1. PDI, ERp72 and ERp57 are endoplasmic > reticulum (ER)-resident eukaryotic proteins involved in oxidative protein > folding. They are oxidases, catalyzing the formation of disulfide bonds of > newly synthesized polypeptides in the ER. They also exhibit reductase > activity in acting as isomerases to correct any non-native disulfide bonds, > as well as chaperone activity to prevent protein aggregation and facilitate > the folding of newly synthesized proteins. PDI and ERp57 have the abb'a' > domain structure (where a and a' are redox active TRX domains while b and > b' are redox inactive TRX-like domains). PDI also contains an acidic region > (c domain) after the a' domain that is absent > in ERp57. ERp72 has an additional a domain at the N-terminus (a"aabb'a' > domain structure). ERp57 interacts with the lectin chaperones, calnexin and > calreticulin, and specifically promotes the oxidative folding of > glycoproteins, while PDI shows a wider substrate specificity. ERp72 > associates with several ER chaperones and folding factors to form complexes > in the ER that bind nascent proteins. EFP1 is a binding partner protein of > thyroid oxidase, which is responsible for the generation of hydrogen > peroxide, a crucial substrate of thyroperoxidase, which functions to > iodinate thyroglobulin and synthesize thyroid hormones. 0 null > 104 1e-16 > > > With this message > expected 21 columns of data but found 16 > > If I change the substring a"aabb'a' to a''aabb'a' (two consecutive 's > instead of ") the record loads. > > I think this has been fixed in more recent versions of the SQLite command-line shell. What version are you using? > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
