Professional Web Applications Themes

read text file insert into database - Macromedia ColdFusion

Hi, I have a tab delimited large text file in my server. I am trying to create a .CFM file to read the text file and insert into the database. Please help with any code example. I would appreciate your help. Thanks.....

  1. #1

    Default read text file insert into database

    Hi, I have a tab delimited large text file in my server. I am trying to create
    a .CFM file to read the text file and insert into the database. Please help
    with any code example. I would appreciate your help. Thanks..

    navee Guest

  2. #2

    Default Re: read text file insert into database

    Try this:



    Read in the file:
    <cffile action="read" file="#pathToFile#" variable="variables.myFile">

    Loop over each row:
    <cfloop index="curLine" list="#variables.myFile#"
    delimiters="#chr(10)##chr(13)#">
    Do work in here...
    </cfloop>

    Inside the above loop, you could loop over the content of the line using
    another CFLOOP
    with the list="#curline#" and tab as the delimiter. Or you could access
    specific items
    using ListGetAt() and again using tab as the delimiter.

    blewis Guest

  3. #3

    Smile Re: read text file insert into database

    Thanks for your valuable post....
    Unregistered Guest

Similar Threads

  1. read the text file
    By newcf in forum Coldfusion - Getting Started
    Replies: 13
    Last Post: September 2nd, 02:54 PM
  2. insert flat file to database
    By chingc in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: June 22nd, 02:29 PM
  3. Replies: 2
    Last Post: July 11th, 12:46 AM
  4. Replies: 1
    Last Post: June 30th, 08:47 PM
  5. Replies: 1
    Last Post: August 12th, 03:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139