I am using mysql for the first time and I need to create a table using syntax to population a table with approximately 6000 rows. I am having trouble figuring out Bulk Import and Import From and am finding the explanations on the internet to be over my head. Can anyone explain this using language and steps suitable for a beginner?
I'm beginner-level with R, trying to work with a CSV file. I've noticed some rows are being interpreted incorrectly, and would like some help figuring out a way around that. I think the problem is escaped quotes not being parsed how I would like. [more inside]
Does anyone know of a friendly program for batch-converting a folder full of hundreds of HTML tables to CSV format that will load in Google Spreadsheets? I know I could just load one in Excel but I need to automate it to handle tons of these files.
Is there such a thing as a Document-Oriented Database for Non-Programmers? I've been searching the web for several days and I'm quite confused so I thought to post here. [more inside]
I am using Excel 2011 on Mac OS X Lion. I have a workbook created by a colleague with 25 worksheets in it. I would like to export all of these to individual csv files. Is there a way to do it all in one batch? [more inside]
Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
I want to create a spreadsheet from the hyperlinks and words in a word list on Wiktionary. Please take me through the steps. Thanks! [more inside]
Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,ask:3,meta:2,projects:5,jobs:5,music:6,irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this? [more inside]
Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC. [more inside]
I have a large number of books that I want to donate to a library or sell. I want to give my friends and family first pick at anything they want (my primary aim is to quickly reclaim the physical space used up by the books). I need a workflow that will allow me to scan the books' UPCs, etc. with my iPhone 4's camera and end up with an email-able spreadsheet pre-populated with ISBN/Title/Author. Columns for genre, edition and/or year, and short blurbs would also be welcome. I have a PC laptop with the MS Office suite in addition to the iPhone. What are my options? Thanks, hivemind!
Programming challenge: pull XML data with an HTTP GET, process and/or lightly transform it, and output a csv file. Please help me figure this out in Java or tell me what other language to use. [more inside]
perl or sed or awk help for newbie [more inside]
I have several hundred machine-generated, human-readable TXT files; one text file per serialized device tested. Each file has test values in predictable places, although in a very irregularly-shaped "table" if you could even call it that. I want a simple Windows program where I say: "Okay, program, here's the row and columns where field #1 starts and ends, ... here's the row and columns where field #n starts and ends ... Give me a CSV file with those values I need and nothing more." [more inside]
Excel is treating me like a child because it thinks I can't tell the difference between .csv and .xlsx. It's wasting my time. Help? [more inside]
I desperately need help importing a CSV file as EMAIL into Outlook 2010 inbox. [more inside]
On a Win7 desktop, how can I open and read a 1.61 GB CSV file containing text (kind of an archive of e-mails) without freezing up the system?
About a dozen people have tried to solve this. All failed. Exporting from Excel to .csv causes cells to show #NAME? instead of the actual value. [more inside]
I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside. [more inside]
Advice on converting XML to csv. [more inside]
MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
Extract Multiple Data (email, names, dates, and IDs) from a Huge Messy Text File, and Sort Them into a CSV: How do I do this? I've read this on extracting emails, but I can't figure out how to do this with several different data points. [more inside]
How can I export data from a SQL database into a CSV file and add a new column at the same time? [more inside]
I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out. [more inside]
What are best enterprise level Web Analytic / Stat programs that work with IIS and Apache sever logs? [more inside]
Is there a simple, elegant way to iterate over columns in CSV files using Python? [more inside]
How to tell how many rows are in an excel file? [more inside]
I am trying to make a python script that takes a CSV file and turns it into an HTML table. I need it to combine a column containing a website name and another column containing a URL into an HTML link. [more inside]
Using a relational table in a one-to-many relationship in Access, what is the best way to export a csv file with one row per record (from the one half) with a variable number of columns (from the many half)? [more inside]
ExcelMacroFilter: Writing a macro that imports a series of .csv files into their own worksheets in the same workbook in Excel 2007 would save me ridiculous amounts of time. I have written a macro to import the files and rename the worksheet accordingly, but I'm new to VBA and can't for the life of me work out how to get Excel to automatically repeat the import from File_1.csv to File_x.csv. Help please? [more inside]
I have a CSV file relating a measurement value with elapsed time. I'd like to overlay the changing measurement value over a video, using the time values in the CSV to sync the two. I have a MacBook, iMovie, and not much else. Is there a reasonably cheap or free way to do this?
I'm using a shell script to handle some excel docs by converting to csv and reformatting it a little bit. I'm having some difficulty going on with the next part of the script. Some help would be great. :) [more inside]
This is a long question about CSVs, Excel, Imports and byte-sizes. Here's the rub: I have two completely identical files. They contain exactly the same characters in the same order. One has been opened and saved (Not altered in any way) in Excel. The other has not. The one opened in Excel is 20 bytes larger. The ERP will only accept the one saved in Excel. Why? More inside. [more inside]
How do I view .csv (comma-separated values) files IN Firefox in a nice fixed-width column format? [more inside]
Excel is chapping my hide. I have a comma-delimited .csv which contains quote-demarcated text fields. The source of my never-ending joy is the recurrent use of inch-marks and commas within the textfields. Right this way... [more inside]
I have a large amount of csv data that I need formatted in a certain way. How do I do this? [more inside]
Excel: I have a long list of 2000 items addresses in a csv. That single column is all there is. Need to chop that list into 10 separate csv files of 20 items each. Is there a way to automate this? [more inside]
I need a freeware app that can efficiently view and edit massive CSV files. I have a couple of 6K column csv files I need to look at and edit. [more inside]
How can I take a sports schedule in a table format and easily make an iCal calendar? [more inside]
What's the simplest way for me to grab a daily digest of my twitter output? [more inside]
I have a mysql table, and i have a csv file. I need to update some(not all) rows in the mySQL DB using the data in the CSV file. Is there an easy way to do it? There are about 2700 rows that need to get updated. 3 of the cols. in the CSV can be used to find the correct rows in the DB (and yes, I am in fact a n00b) (everything is on a windows machine)
I need to save an Excel csv file of numbers with leading zeroes (e.g., 00987654). [more inside]
What are the field names for importing a csv file into google calendar besides (Subject, Start Date, Start Time) and do you have any cool tricks when importing info into googlecal?
I've just uploaded a .csv email list of about 9000 people to phplist... but phplist shows the list as having 0 members. (Actually, I've gotten this result twice... with two different 9000 member lists.) Any guesses as to what I'm doing wrong... or what I should be doing differently? Thanks! (Host: Hostgator)
Using OpenOffice Calc (Spreadsheets) - Is there any way to divide the strings in one column into two by the space in each cell? [more inside]
Converting CSV to TAB: is there a free software for this? [more inside]
ParseFilter: I have a CSV file full of leads I need to parse into a more, er, concise format. What would the hive mind recommend? [more inside]
(Geekfilter) Can I convert Earthlink TotalAccess (WinXP PC) Email (.dat or .csv) mailboxes to Apple Mail (.mbox) mailboxes on a Mac? (AKA: How can Earthlink be this stupid?) [more inside]
I am trying to find a way to generate a CSV table based on output from two or more command line programs (DOS on Windows XP). [more inside]
Automate Excel Filter..... I am getting via email a CSV file daily that I would like to automate into excel. [more inside]
Page: 1 2