Skip to main content
C
cfnew
Known Participant
June 5, 2009
Question

upload .txt file to database in coldfusion

  • June 5, 2009
  • 1 reply
  • 972 views

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

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
June 5, 2009

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices