Related post

I am trying to extract some data from an array with the following syntax: @entries_from_db = XrEntry.find(:all, :conditions => [:FeedURI => uri ], :select => 'json') The :FeedURI is the record that contains an array with uri's ["123456", "23

Is there a simple way, using some common Unix scripting language (Perl/Python/Ruby) or command line utility, to convert an Excel Spreadsheet file to CSV? Specifically, this one: http://www.econ.yale.edu/~shiller/data/ie_data.xls And specifically the

I am trying to create a simple alert app for some friends. Basically i want to be able to extract data "price" and "stock availability" from a webpage like the folowing two: http://www.sparkfun.com/commerce/product_info.php?products_id=5 http://www.s

I have a web service that I want to access when it is added as a web reference to my C# project. A particular method in the web service takes a SQL query string and returns the results of the query as a custom type. When I add the web service referen

I know this is really basic, but I am new to MATLAB. After opening a .fig file, how do you actually work with the plotted data in the command window? All I see is the plot. I'm not sure how to actually get the data. --------------Solutions-----------

I have a situation where I need to extract dates from the file names whose general pattern is [filename_]YYYYMMDD[.fileExtension] e.g. "xxx_20100326.xls" or x2v_20100326.csv The below program does the work //Number of charecter in the substring is se

I'm using c# and visual studio to extract data from an excel sheet, put it into an array (adding commas to the end of each string) and then output it to a .CSV file. Now I've run into a snag that occurs when a cell has either no data, or not the data

i try to make a kind of "sql distinct" request with core data, so i set up my NSFetchrequest like this NSFetchRequest *fetchRequest = [[NSFetchRequest alloc] init]; [fetchRequest setEntity:[NSEntityDescription entityForName:@"my_table" inManagedObjec

I've been wondering about the possibility of generating a strongly-type object from the formcollection to extract data from it. In other words, is it possible to generate a class depending on the keys in the formcollection object? For example: Say yo

I've been searching for some time to figure out how to extract data from a remote XML file and then create a post automatically with the parsed XML data. I have figured out the functions to create a post using cURL/PHP but I'm not sure how to pull da

I would like to get data from a single contour of evenly spaced 2D data (an image-like data). Based on the example found in a similar question: How can I get the (x,y) values of the line that is ploted by a contour plot (matplotlib)? >>> imp

I have two files xml, and I need to extract data from first xml file and insert in to second xml file. first file: <?xml version="1.0" encoding="utf-8"?> <ITEMS> <EVENT> <codpal>8387</codpal> <programming>ProgramNa

I have this code which extracts data from a csv file and then reformats it so that it can be compared with another data set: def dataExtract dates = File.open(@filename_data).read.scan /\d{2}\/\d{2}\/\d{2}/ data_extracted = [] index = 0 dates.each do

Relatively newbie here with a little question. I been extracting a json string that looks like this (in this case it is a modified return from Facebook oauth2. {"id":"555555555555555","name":"Monkey Man","last_name":"Man","first_name":"Monkey","email

Assume we have a sequence of bytes with header of '807F' which is input to PC through RS232. for example "... 80 7F 4B 97 80 7F 21 3A 80 7F ... " in which "21 3A" is our data in bold package and 21 is MSB and 3A is LSB. how can we extract data from t

I am using an xls file which is "already filtered" as input for my software. So i need a way to extract only the filtered information into an object array using C# .net . But somehow, when i try to extract data from the xls, i always happen to get th

Hello. Read through many of the helpful answers on macros/VBAs ... but as I've never done a macro/VBA, hopefully someone can help. I have 5 sheets in a workbook and need to extract data from all of them into 3 new sheets. Each sheet has data in Colum

I need to extract data from a .mpp file on the network and combine it with other data from several different databases. The application can be written in Perl, VB6, VB.net or C# but must be easily scheduled from a Windows based server. What would you

We have an architecture where we use SSIS to extract data from XML batch files into a staging database for validation, prior to exporting it into production. We control the XML format to some extent, and I've been asked to determine what the maximum

I am using the MSXML4.0 parser in VB6. I have an XML file that is browsed and selected by the user. The XML contains lot of tags.I am intersted in mining out the data that is contained in the child nodes of a tag named leadmeasurements. The lead meas

My company receives data from an external company via Excel. We export this into SQL Server to run reports on the data. They are now changing to PDF format, is there a way to reliably port the data from the PDF and insert it into our SQL Server 2008

I have a DataTable that is filled in from an SQL query to a local database, but i don't know how to extract data from it. Main method (in test program): static void Main(string[] args) { string connectionString = "server=localhost\\SQLExpress;databas