You need awk. It is tailor-made for this kind of task. There is a Windows version if that's what you're running. It can easily go through the records and insert a delimiter at a certain character position. It shouldn't take more than one line of code to accomplish the task.
On Wednesday 01 May 2002 09:36 am, Ramon Arias wrote: > Jay > > I need to break it up into fields.... > > Ramon > > -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 9:26 AM > To: 'Ramon Arias'; [EMAIL PROTECTED] > Subject: RE: mysqlimpor and fixed length files. > > > [snip] > Is there a way to import data that is in fixed length format into MySQL? > [/snip] > > Do you need to break up the data, or can it all just go in one column? > > Jay Blanchard > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
