I am generating a csv (comma separated value) file with Java Server Pages (JSP). The URL shows "my_generated_csv.jsp". What I want to do is simple: The user clicks "Generate" which downloads the generated CSV file. I'd like to generate it with the JSP. Do I need to rethink my approach? Edit: The following code works to make the file d...
Here's a (simplification of a) task I do a lot: 1) Import a CSV file like the following: 1, cat, 10, junk 2, dog, 20, junk 3, mouse, 30, junk 2) Remove the fourth column and replace it with twice the third column. 3) Insert a new column that is half the third column. 4) Export to to CSV, ie: 1, cat, 5, 10, 20 ...
Does the .net framework have any builtin assemblies for handling reading and writing from and to text delimited files? Or is this something I have create myself? ...
Does anyone know if there is application that will let you covert preferably xls to JSON. ill also settle for a converter from csv since thats what ill probably end up having to write myself if there is nothing around. ...
I am exporting data from a database using PHP to convert it into a CSV. I figured it'd be useful to provide the first row with a title (similar to the <th> element in HTML) so the end user would understand the column's meanings. Example ============= | id | name | ============= | 0 | tim | | 1 | tom | ============= Which would loo...
Dim re As New Regex("((?<field>[^"",\r\n]+)|""(?<field>([^""]|"""")+)"")((?<rowbreak>,\r\n|\r\n|\n|$)|,)") 3700,Collin,Franc,,[email protected],Collins,Francine,,[email protected],"Enel North America, Inc.",One T Drive,Suite 220,MyCity,MA,77774,1,[email protected],,,,,3700, 3701,Steur,Larry,,[email protected],Steur,Larry,,[email protected],...
Hi, I'm importing data from a CSV that contains approx 350 columns. This CSV import is fixed and I have absolutely no control over it. If I attempt to open the CSV in Excel 2003, it only partially loads due to the column limit of 255 (IV). When I load the CSV into a DataSet using OleDb and Microsoft.Jet.OLEDB.4.0 it also only shows 25...
I have a need to read a CSV file, and the only language I can use is VBscript. I'm currently just opening the file and splitting on commas, and it's working OK because there aren't any quoted commas in fields. But I'm aware this is an incredibly fragile solution. So, is there such a thing as a VBscript module I can use? Somewhere to ge...
I am using the SQL Server Report Server from Microsoft SQL Server 2005. In the report server report viewer control, there is a CSV download option. The CSV download option is currently downloading a Unicode CSV file, which does not load into Microsoft Excel with the correct column formatting. If I save the Unicode CSV file and convert...
I have a function that exports a table into a CSV file, then I open that file using a spreadsheet application. Is there a way to set the header of the CSV to name each column appropriately. For example: I have a table the contains first name, last name, email, and comments. And the table is set as: fname, lname, email, comments So t...
I'm learning Python as my second programming language (my first real one if you don't count HTML/CSS/Javascript). I'm trying to build something useful as my first real application - an IRC bot that alerts people via SMS when certain things happen in the channel. Per a request by someone, I'm (trying) to build in scheduling preferences ...
Is there a simple Java library or approach that will take a SQL query and output the result to a CSV file? Update: I found there were a couple other related SO posts existing (1, 2) ...
Hi I have a CSV output on one of my applications. This produces a file from of web form data. In some cases I am getting a carriage return character in my notes field. This causes an error when importing the file. I would like to remove this character. The issue appears to be happening when users paste information into the form from w...
Hello everyone, I'm looking for a way to loop through the columns of a table to generate an output as described below. The table looks like that: ID Name OPTION1 OPTION2 OPTION3 OPTION4 OPTION5 1 MyName1 1 0 1 1 0 2 MyName2 0 0 1 0 0 And the output looks like that: MyName...
I'm using CSVDE to export data from our active directory into a CSV file, which then gets imported into a database. I'm using the -l switch to specify the columns that I'd like to export, but they don't come out in the same order consistently. Is there a workaround for this that doesn't involve opening the file in Excel? This is a nig...
Hi I have a table with data in it as such: Cars: id | name ---------- 1 | Buick 2 | Honda 3 | Toyota What I would like to do in a Stored Proecdure is get the result like this: Temp Table: Buick | Honda | Toyota ---------------------- I realize it has no values, but I just want to get this part first. I am guessing this would in...
Hi, all. I wrote a VB.net console program to process CSV record that come in a text file. I'm using FileHelpers library along with MSFT Enterprise library 4. To read the record one at the time and insert into the database. It took about 3 - 4 hours to process 5+ million records on the text file. Is there anyway to speed up the proc...
Can SQL Server Grid "Save As" be changed to write out an encoding that is Text instead of UTF-16? When I right click a Result Grid in SQL Server it allows for a Save As .CSV. Currently it saves the .CSV file encoded as UTF-16 (Unicode) but Excel does not open this format automatically (Excel prompts for a delimiter). To get around the p...
I'm trying to output query results in comma delimited format using the mysql command line tool. My mysql user does not have access to use the "INTO OUTFILE" option referenced in this question: http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format I'm also aware of the -H and -X options to format ou...
I have a CSV file with quote text delimiters. Most of the 90000 rows are fine, but I have a few rows that have a text field that contains both a quote and a comma. For example the fields value would be: AB",AB When Delimited this becomes "AB"",AB" When SQL 2005 attempts to import this I get errors such as... Messages Error...