Thank you for the help. It seems I am still missing the line feed somehow.
This is an example of the text that is giving me a problem, copied straight from the db: "Laurel Burch artistic tote, JIO's cats (style 4380 Large Square Tote) is a roomy 22" by 4" by 15.5". The inside pocket combination has a zippered pocket, an open pocket, a velcro closure cell phone pocket. The front kitty design has sequins and embroidery detail. A striped pattern is on the back. Top zipper closure. Includes a carved wood, hand painted kitty hang tag. " For some reason I am not catching it. Am I missing a character that I should be replacing? This is what I have: <cfset lineoutput = lineoutput & replacelist(qry_productsGetForIndex.shortdescription, "#chr(13)##chr(10)#,#chr(9)#,#chr(12)#", " ") & chr(32) & replace(qry_productsGetForIndex.productDescription, chr(9), " ", "all") & chr(9)> The output to the text file still has the new line. On Sun, Aug 22, 2010 at 6:07 PM, Jason Fisher <[email protected]> wrote: > > Depending on what you need to replace those chars with, this will simply > remove them: > > <cfset testString = replaceList(subject, > "#chr(13)##chr(10)#,#chr(9)#,#chr(12)#", ",,") /> > > (I assumed that 13 & 10 were a single EOL set, but you could add a comma > in between there and in the replacement set, if needed.) > > - Jason > > > On 8/22/2010 6:49 PM, Matthew Smith wrote: > > I am trying to write a file to be uploaded to google base. I am having a > > problem with the formatting. I'm not sure, but I think the item > description > > might have some of those characters in them. What is the easiest way to > > remove the subject line's characters? > > > > I could wrap a replace in a replace etc but that seems sloppy. > > > > Thank you. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:336454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
