I have a query that is pulling user comments, supplied by via web internface and creating a text file out of them. In these comments are all sorts of carrige returns. I've tried stripping them out with the following queries, but once imported into excel, the carrige returns are still there. so obviously i'm doing something wrong.... I tried doing with the ASCII number .....(no idea if this is valid) SELECT Business_Unit.Business_Unit, Category.Category_Name, REPLACE(Comment_Original, ASCII(10),ASCII(32)) FROM `Comment` INNER JOIN Cat egory ON Comment.Category_ID = Comment.Category_ID INNER JOIN Survey_Response ON Comment.Survey_Key = Survey_Response.Survey_Key INNER JOIN Business_Unit ON Survey_Response.BUKey = Business_Unit.BUKey WHERE Comment_Original <> ' ' AND Category.Category_Name IS NOT NULL GROUP BY Business_Unit.BUKey, Category.Category_Name, Comment_Original ORDER BY Business_Unit.BUKey, Category.Category_ID ASC INTO OUTFILE '/export/home/jdyke/comments_NoB.csv' fields terminated by ',' OPTIONALLY ENCLOSED BY '"' lines terminated by '\n'; Also with the escaped charatcer. SELECT Business_Unit.Business_Unit, Category.Category_Name, REPLACE(Comment_Original, '\n',' ') FROM `Comment` INNER JOIN Category ON Co mment.Category_ID = Comment.Category_ID INNER JOIN Survey_Response ON Comment.Survey_Key = Survey_Response.Survey_Key INNER JOIN Business_UnitON Survey_Response.BUKey = Business_Unit.BUKey WHERE Comment_Original <> ' ' AND Category.Category_Name IS NOT NULL GROUP BY Business_Unit.BUKey, Category.Category_Name, Comment_Original ORDER BY Business_Unit.BUKey, Category.Category_ID ASC INTO OUTFILE '/export/home/jdyke/comments_NoB.csv' fields terminated by ',' OPTIONALLY ENCLOSED BY '"' lines terminated by '\n'; Is REPLACE the right SQL Function to use? is there a better way to determine this character? Thanks Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
