Professional Web Applications Themes

replacing carriage returns in file - Macromedia ColdFusion

Hi, I have a file that I want to import into excell. In order to do that it must be delimited in some manner, because currently it is formatted for each new line being a row. I want to replace the new lines with some other character so that I can use it as the delimiter. I can get the file to open, to change some things, and to write to a new file, but the replace funtion isnt doing what I intend. I spent some time today looking for the answer, but so far I havent found it. I ...

  1. #1

    Default replacing carriage returns in file

    Hi,

    I have a file that I want to import into excell. In order to do that it must
    be delimited in some manner, because currently it is formatted for each new
    line being a row. I want to replace the new lines with some other character so
    that I can use it as the delimiter. I can get the file to open, to change some
    things, and to write to a new file, but the replace funtion isnt doing what I
    intend. I spent some time today looking for the answer, but so far I havent
    found it. I have tried several variants of what I am replacing in the function,
    but still nothing seems to be working correctly. Surely it is something simple
    that I am overlooking. Can anyone shed some light on this for me? Thanks so
    much.

    <cffile action = "read" file = "C:\wwwroot\directorySample\test.txt" variable
    = "fileIn">
    <cfset fileOut = ReReplace(#fileIn#,"chr(10)",">","ALL")>
    <cffile action="write" file="C:\wwwroot\directorySample\result.txt"
    output="#fileOut#" attributes="normal">


    the real rob rone Guest

  2. #2

    Default Re: replacing carriage returns in file

    sorry. I found the answer. I had quotes around my chr codes. ")

    <cfset fileOut = ReReplace(#fileIn#,chr(10),">","ALL")>
    the real rob rone Guest

Similar Threads

  1. Removing carriage returns...
    By JakeFlynn in forum Macromedia ColdFusion
    Replies: 3
    Last Post: April 5th, 08:54 PM
  2. XML, carriage returns and special characters.
    By Johnny Walker in forum Macromedia Flash
    Replies: 6
    Last Post: January 3rd, 03:00 AM
  3. My XML import into inDesign doubles the carriage returns
    By Ben_Marchbanks@adobeforums.com in forum Adobe Indesign Windows
    Replies: 0
    Last Post: April 17th, 12:23 PM
  4. replacing carriage returns?
    By yawnmoth in forum PHP Development
    Replies: 1
    Last Post: November 1st, 11:57 AM
  5. Extra carriage returns - why?
    By Bob Walton in forum PERL Miscellaneous
    Replies: 3
    Last Post: September 10th, 11:35 AM

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