New topic: Line breaks or manual enter for new line
<http://forums.realsoftware.com/viewtopic.php?t=47015> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message McDian Post subject: Line breaks or manual enter for new linePosted: Thu Feb 21, 2013 1:23 pm Joined: Fri Sep 14, 2007 5:00 pm Posts: 386 Best title I could come up with. Okay so here is the problem I am running into. I have a field in my database (SQLite) that stores in BLOB. It's essentially a notes section within my application. The data gets stored just fine but when I try to export it I get a funky out put. See Below: I00701,2010-01-25,2010-02-22,107764,107970,00:00:00,0.1,99999999,28,0.736,20.6,201002,0.94,,,,,"Number of use days have changed from Use Days to 28. Use per day has changed from 25.982 to 0.736. Usage has changed from Meter Use to 20.600. Meter Cost has changed from 33.45 to 0.94.",Automatic,,,, I11501,2010-01-26,2010-02-22,21820,21820,00:00:00,10,999999,27,0,0,201002,0,,,,,,Automatic,,,, The output (it's a CSV format) above is what I get, below is what I want: (I made some edits for formatting) I00701,2010-01-25,2010-02-22,107764,107970,00:00:00,0.1,99999999,28,0.736,20.6,201002,0.94,,,,,"# of use days changed from 46 to 28. UPD changed from 25.982 to 0.736. Usage changed from 65.250 to 20.600. Meter Cost changed from 33.45 to 0.94.",Automatic,,,, I11501,2010-01-26,2010-02-22,21820,21820,00:00:00,10,999999,27,0,0,201002,0,,,,,,Automatic,,,, So the problem is in the area in blue above. When I export the BLOB field apparently assumes the line break or new line from pressing enter, is a new element for the CSV. I don't know how to test for this let alone how to correct it so I get the desired output. I don't really know how else to explain it. If I could attach a sample of the data file that I am getting that might help. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
