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:337000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
