sql - Selecting different number of columns in a CSV file -

-

the task extract data multiple csv files according criteria. file contains sampleid (this criteria) , other columns. @ end of file there measurement values under 0...100 named columns (the numbers actual names of columns). make bit more interesting there can variations in different csv files, depending on customer needs. means measurement data count can 15, 25, 50 etc. no more 100 , no variations within 1 file. data placed in end of line, there set of columns before numbers.

i'd have sql statement can accept parameters:

select {0} {1} sampleid = {2}

0 numbers, 1 csv file name , 2 sampleid looking for. other solution came mind columns after last fix column. don't know possible or not, thinking out loud.

please descriptive, sql knowledge basic. appreciated.

so managed solve it. code in vb.net, logic quite clear.

 private function getdatafromcsv(sampleids integer()) list(of keyvaluepair(of string, list(of integer)))            dim datafiles() string = system.io.directory.getfiles(outputfolder(), "*.csv")            dim results list(of keyvaluepair(of string, list(of integer))) = new list(of keyvaluepair(of string, list(of integer)))            if datafiles.length > 0 , sampleids.length > 0                   index integer = 0 sampleids.length - 1                        if sampleids(index) > 0                             each file in datafiles                                  if system.io.file.exists(file)                                       dim currentid string = sampleids(index).tostring()                                       dim filename string = path.getfilename(file)                                       dim strpath string = path.getdirectoryname(file)                                     dim conn oledb.oledbconnection = new oledb.oledbconnection("provider=microsoft.jet.oledb.4.0; data source=" & strpath & "; extended properties='text; hdr=yes; fmt=delimited'")                                     dim command oledb.oledbcommand = conn.createcommand()                                     command.commandtext = "select * [" & filename & "] 'where sample id = " & currentid                                     conn.open()                                    dim reader oledb.oledbdatareader = command.executereader()                                    dim numberoffields = reader.fieldcount                                      while reader.read()                                             if reader("sample id").tostring() = currentid 'if found write particle data output file                                                  dim particles list(of integer) = new list(of integer)                                                  field integer = 0 numberoffields - 1                                                      particles.add(cint(reader(field.tostring())))                                                  next field                                                  results.add(new keyvaluepair(of string, list(of integer))(currentid, particles))                                             end if                                        end while                                        conn.close()                                   end if                              next file                     end if                next index                return results           else                messagebox.show("missing csv files or invalid sample id(s)", "internal error", messageboxbuttons.ok, messageboxicon.exclamation)          end if          end function

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more