Try Chr(10) also like: <cfset newcsvfile = replace(csvfile, '#chr(10)#', '', "ALL")>
I just had to do that with a message digest that wasn't being verified correctly, Phil On Tue, Sep 14, 2010 at 1:17 PM, Phillip Vector <vec...@mostdeadlygame.com>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:337004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm