Posted by Tim Van Wassenhove on 05/07/06 14:03

On 2006-05-07, Alex Murphy <murphychan168@gmail.com> wrote:
> The database is using text file to store the data. I using "list" and
> "split" function to split the "|" delimiter.
> This text file will upload to the server from the shop everydays.

Well, then it's about time to start looking at the manual of your SQL
DBMS. You'll find a section that allows you to use 'normalize' the data
and you'll find a section that allows you to import CSV (or other delimiter
separated value) files.

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>

[Back to original message]