Partitioning File

Question

[alex]

I have a file here :

<ftp://ftp.ncbi.nih.gov/pub/geo/DATA/supplementary/samples/GSM391nnn/GSM391674/GSM391674_r1s1_eland_out.txt.gz>

I want to partition the file into a table that I create. I am used to comma or pipe delimited files. How would you break this up and what would your columns be? Thanks!

[alex]

btw I am using a mysql database

Answer 1

[seidel]

If that's an eland output file, the delimiter is a tab character. You can read it straight into MySQL, as tab is the default delimiter for LOAD DATA INFILE statements in MySQL. If you want to break it up, or only keep certain columns, that would depend on what you plan to do with the data. Otherwise, you could simply look up the structure of an eland output file, and specify your table design accordingly.

Your question would be better for everyone if it were more descriptive. You can point to a file, but you should also describe it as much as you can, so someone reading the question at a later point can see your problem, and understand how the answer relates. It doesn't have commas or pipes as the delimiter, but what do you think the structure is? How do you want to break t up? What columns are you interested in? What are you planning on doing with the data?