mightyx Posted July 27, 2007 Share Posted July 27, 2007 Hello everyone, we just created an export module for orders. The export module creates a semicolon ( ; ) separated CSV file with customer and delivery data, products ordered... There's one big problem: If the customer uses a semicolon in his address or the comment, the whole data is scrambled, because columns don't match anymore. My question: Is there a way to tell osc not to accept semicolons in input fields or to erase them when generating the CSV file? Thans for your help! Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted July 27, 2007 Share Posted July 27, 2007 I would allow the input and only during export I would replace the semicolon by a comma the php function to use is str_replace :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.