replacing carriage returns in file

Ask a Question related to Macromedia ColdFusion, Design and Development.

  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. Similar Questions and Discussions

    1. Removing carriage returns...
      Here is the code that I am using to try and remove the Carriage Returns and Line Feeds and replace them both with spaces: ...
    2. XML, carriage returns and special characters.
      Hi, I'm trying to add dinamic content to my site using Flash and XML. Here is an example: <?xml version="1.0" encoding="utf-8"?> <PHOTOS>...
    3. replacing carriage returns?
      so... i'm trying to remove all carriage returns in the input i get from GET, and am trying to replace them with three dots... however, this...
    4. Carriage returns/formatting not displayed in output.asp
      Dear Colleagues: To begin with I am not a programmer. In fact, I just got all excited because I was able to create my very first .vbs script...
    5. Extra carriage returns - why?
      John Andrews wrote: From previous post in thread: perl -pe 's/NEVERFOUND/NEVERFOUND/g' < foo > bar Hmmmmmm...I was unable to duplicate...
  3. #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

Posting Permissions

  • You may not post new threads
  • You may 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