Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

upload .txt file to database in coldfusion

New Here ,
Jun 05, 2009 Jun 05, 2009

Hi i need to know how  to upload text file in to database using coldfusion and the file does not have any column names. Can anyone help me in this.

The sample of data in file is:

00012009032216001111039289000005.9900100000000000000.00

TOPICS
Getting started
922
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 05, 2009 Jun 05, 2009
LATEST

You can start by using list functions.  After uploading and reading the file, you can treat the resulting variable as a list delimited by chr(10) & chr(13).  As far as processing each line goes, you have to know it's structure.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources