In Windows a line feed is actually #chr(10)##chr(13)#. However, if you remove those you will probably remove ALL line feeds in your file instead of just the double line feed that is causing you problems. This can be tricky, but you will probably want to look for #chr(10)##chr(13)##chr(10)##chr(13)#, or something like that. Line feeds can be a real pain in the butt because different software will give you different line feed combinations.
Sent with my Android phone On Sep 14, 2010 11:19 AM, "Phillip Vector" <[email protected]> wrote: > > I have the following data... > > bb0a0933-85d4-44be-a72c-25aa759c603f,3782049,DirectMail,63933-8188,The > form ProgramForms has been rejected because of the following reason: > bb0a0933-85d4-44be-a72c-25aa759c603f,3782049,DirectMail,63933-8188,"The > form (Application Form) has been rejected because of the following > reason: 0002 -Missing proof of program participation > 1023 -SSN not provided" > 70d4eeca-047d-42e5-8648-25abe1579c96,3784291,DirectMail,07055-2931, > > The issue I have is that on the second record (ID: > bb0a0933-85d4-44be-a72c-25aa759c603f), they use 2 lines when there is > more then one reason why the app was rejected. I suspect that they are > using CTRL-Return or some such to put it in. > > The question is.. How do I remove it and make it one line again with a > cfreplace command? I use commands like > > <cfset newcsvfile = replace(newcsvfile, ',,', ',0,', "ALL")> > > to basically scrub the data. So how would I do it for a situation like > this? When I try > > <cfset newcsvfile = replace(csvfile, '#chr(13)#', '', "ALL")> > > It doesn't remove it.. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
