Dear Axel, Thank you so much for your valuable help. This information does helps a lot for sure.
Will try that and let you know how it went. Best of regards, Paul El jun 2, 2014 4:06 AM, "Axel Klenk" <axel.kl...@actelion.com> escribió: > > Dear Paul, > > if I had to do that, I would look at function read.fwf() for importing your > fixed width formatted text file and at package RODBC for connecting > to your database (or function write.csv() for exporting as a CSV file). > > Hope this helps, > > - axel > > > On Fri, May 30, 2014 at 4:40 PM, Paul Bernal <paulberna...@gmail.com> > wrote: > >> Hello everyone, >> >> I have a text file which has no field name, however, I have a document >> that >> says how the fields are sepparated (for example, field ship number goes >> from position 1 to position 5, field vessel name goes from position 7 to >> position 15, and so on). >> >> I need to populate already created tables (contained in microsoft sql >> server management studio) with the data contained in this text file . >> Either that or convert that text file into a csv file so that it can be >> read in easily. >> >> Does R has a function that helps doing this or is there a way that R can >> help? What options do I have? >> >> Best regards, >> >> Paul >> >> [[alternative HTML version deleted]] >> >> _______________________________________________ >> R-sig-DB mailing list -- R Special Interest Group >> R-sig-DB@r-project.org >> https://stat.ethz.ch/mailman/listinfo/r-sig-db >> > > > > -- > > > Axel Klenk > Research Informatician > Information Management Drug Discovery > > Actelion Pharmaceuticals Ltd. ⢠Gewerbestrasse 16 ⢠CH-4123 Allschwil ⢠> Switzerland > H91.O1.W01.2 > > axel.kl...@actelion.com ⢠www.actelion.com > Address for visitors: Hegenheimermattweg 91 > > > The information of this email and in any file transmitted with it is > strictly confidential and may be legally privileged. > It is intended solely for the addressee. If you are not the intended > recipient, any copying, distribution or any other use of this email is > prohibited and may be unlawful. In such case, you should please notify the > sender immediately and destroy this email. > The content of this email is not legally binding unless confirmed by > letter. > Any views expressed in this message are those of the individual sender, > except where the message states otherwise and the sender is authorised to > state them to be the views of the sender's company. For further information > about Actelion please see our website at http://www.actelion.com > > [[alternative HTML version deleted]]
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
