Damned filter. Anything quoted once is my post. Grrr... > database,sql,query,table
> Erica Douglass writes: > > > I have a text file that is fixed-width delimited (that is, fields are > > delimited by certain column widths.) > > > > What is the workaround for this? Will importing large files work if I have > > tab-delimited rows? If so, what is the procedure to convert from > > fixed-width delimited to tab-delimited? > > Yep, there's no way to specify a format like that with LOAD > DATA INFILE, but tab-separated files work like a charm. I'd > probably use sed to convert the data. Here's an example of > something that would do the job for 3-column data with > 3 characters in the first column and 4 in the second. Note > that it doesn't strip trailing spaces from the fields. > sed "s/^\(.\{3\}\)\(.\{4\}\)/\1\T\2T/\3" filename >filename.tab > Replace the letter T with tab. You might have to hit > ctrl-v tab to get a tab in the shell. > > //C > > -- > Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 > [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ > Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php