No need for the extraneous pound signs. <cfset newcsvfile = replace(csvfile, chr(10), '', "ALL")>
On Tue, Sep 14, 2010 at 1:26 PM, Phillip Duba <phild...@gmail.com> wrote: > > 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:337005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm