S
Sharp
Hi
I'm trying to convert a file in FASTA format to a text file in TABLE
(delimited by tab) format for MS Access.
EXAMPLE:
from FASTA format:
ATATATATTATATATATATT
to TABLE format:
12345 ATATATATATATATATATATATATATATTATATATATATT
PROBLEM:
Sometimes the sequence of A's and T's is so long that even in notepad, it
will wordwrap, despite having wordwrap set off. WordPad does a better job
than notepad, and will accept a little more characters per line, but still
in some cases the sequence is too long that it reaches the line maximum and
begins to word wrap. The problem of wrapping is that it becomes difficult to
import the text file into MS Access reliably.
QUESTIONS:
Is there another format I could use that will allow extremely long lines?
I plan to import the sequence as a memo field, which I heard can take many
characters.
I guess another solution is to use JDBC to connect directly to the database
and import it directly to a table, thereby avoiding the need to save it as a
textfile (doesn't work anyway) before I import.
Any advice appreciated.
Cheers
Sharp
I'm trying to convert a file in FASTA format to a text file in TABLE
(delimited by tab) format for MS Access.
EXAMPLE:
from FASTA format:
ATATATATATATATATATAT12345 a description
ATATATATTATATATATATT
to TABLE format:
12345 ATATATATATATATATATATATATATATTATATATATATT
PROBLEM:
Sometimes the sequence of A's and T's is so long that even in notepad, it
will wordwrap, despite having wordwrap set off. WordPad does a better job
than notepad, and will accept a little more characters per line, but still
in some cases the sequence is too long that it reaches the line maximum and
begins to word wrap. The problem of wrapping is that it becomes difficult to
import the text file into MS Access reliably.
QUESTIONS:
Is there another format I could use that will allow extremely long lines?
I plan to import the sequence as a memo field, which I heard can take many
characters.
I guess another solution is to use JDBC to connect directly to the database
and import it directly to a table, thereby avoiding the need to save it as a
textfile (doesn't work anyway) before I import.
Any advice appreciated.
Cheers
Sharp